Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box + option all + use all functions when this is pressed
I have a combo box that contains: 1, 2, 3, and all. These represent
different situations. So for situation 1, it should do function 1. For all I want to be able to do all 3 functions. ok. Now I have a functions that are called: function 1, function 2, function 3 and function all if I say: if combo_box.value=all then for i=1 to 3 controls("function "& i next i end if See what I mean... how can I use functions in a for loop and just assign the index.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box + option all + use all functions when this is pressed
Function names are not held as strings :
e.g. Call MyFunction1(args) Or RetVal=MyFunction1() so you cannot build the name with a variable like that. But maybe you can use Application.Run "MyFunction" & i instead. The functions need to be in a module for this to work. NickHK "Monte0682" wrote in message ups.com... I have a combo box that contains: 1, 2, 3, and all. These represent different situations. So for situation 1, it should do function 1. For all I want to be able to do all 3 functions. ok. Now I have a functions that are called: function 1, function 2, function 3 and function all if I say: if combo_box.value=all then for i=1 to 3 controls("function "& i next i end if See what I mean... how can I use functions in a for loop and just assign the index.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No range option in format control for combo box | Excel Worksheet Functions | |||
Look up Values from other file based on combo box's option | Excel Discussion (Misc queries) | |||
Combo Box "LinkedCell" option | Excel Discussion (Misc queries) | |||
Form Option Buttons and Combo Boxes in VBA | Excel Programming | |||
Control which option is visible in Combo boxes | Excel Programming |