View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Monte0682 Monte0682 is offline
external usenet poster
 
Posts: 15
Default 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....