I would like to use a LISTBOX to choose from about 10 different macros but I don't want the box macro to have the whole IF/Then text...you know, if cells(2, 4) = 1 then and so on.
Can't I just use a string variable to tell it which macro to use?
Please Login or Register to view this content.
Try something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I get an error. It's looking for something in here:
Select Case ListBox1.ListIndex
I'll need a lot more details.
- What was the error number and description?
- Is your listbox named ListBox1?
- Is the list box on a worksheet or in a UserForm?
- Where did you put the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks