Create a Functional Listbox

Computing.Net > Forums > Programming > Create a Functional Listbox

Create a Functional Listbox

Original Message

Name: drm
Date: January 7, 2003 at 00:59:40 Pacific
Subject: Create a Functional Listbox
OS: Win98SE
CPU/Ram: 336Mb

Comment:

I can create and populate the listbox. But I need a tutorial or simple examples on how to set it up so when user clicks on a line, the macro will know what line he clicked. Most everything I have found is far too complicated

Report Offensive Message For Removal

Response Number 1

Name: chad
Date: January 7, 2003 at 06:57:15 Pacific
Subject: Create a Functional Listbox

Reply: (edit)

what language and version are you using? could you show an excerpt of your code? Dont have enough info to make a suggestion.

Report Offensive Follow Up For Removal

Response Number 2

Name: drm
Date: January 7, 2003 at 08:09:58 Pacific
Subject: Create a Functional Listbox

Reply: (edit)

Excel 2000
I Also have M$ Visual Studio 6 but not full blown VB.
Here is Excel file:
.
http://home.twcny.rr.com/suecortland/PhotoIndexTest.xls
.
Of course the photo links were not included because they are 400 Mb ! It will all go on CD when finished.
I have a macro to create a list of photos from user input as a string from titles (ie: Eileen). And this works OK. I want to be able to create a listbox from col. "H", have user select one, and then use the matching string in Col. "I" to create a list using the above macro. I can create the ListBox with ActixeX and populate it. But I got lost trying to develop coding to determine what line user clicked. Of course existing col. H & I could be removed once macro works. I bought 3 books on VB but I cannot seem to get what I need from them. After a week on this I decided it was time to swallow pride and seek help.

Report Offensive Follow Up For Removal

Response Number 3

Name: chad
Date: January 7, 2003 at 11:07:00 Pacific
Subject: Create a Functional Listbox

Reply: (edit)

I have retrieved your Excel file and I'm taking a look. I think I get the general Idea, but I'm not sure excactly what you did with the ActiveX. I Have the full VB 6 as well as Excel thats part of Office 2000. I'm going to take a deep look into what you've done here. What is the source of the data? Internal tables, files, etc???

Report Offensive Follow Up For Removal


Help to create a function in Access Creating a DataBase using Excel VBA Creating a file with a program(vb6) Createing a Custom Keyboard Mapping Create a user profile in Visual C++?	Passing a string to a function creating Visual C++ function VBScript help creating a log file Batch File to Create a Shortcut creating a shortcut thru a bat file

file needs a program

managing one program from...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Create a Functional Listbox

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How often do you use Computing.Net?

Poll Finishes In 2 Days.
Discuss in The Lounge

Windows crashes $ Please Help $

Win32.agent.cnm virus

sata kills os responce.

Logging users and computers

MediaPlayer11- Creating a song list

All Posts Awaiting Replies