I need a little help with Excel - is it possible to assign a macro to each item in a drop-down list? I would have thought M$ would have thought of a linear way to so....or maybe not
Thanks
I need a little help with Excel - is it possible to assign a macro to each item in a drop-down list? I would have thought M$ would have thought of a linear way to so....or maybe not
Thanks
I know that in Access you can use vba to make a little script along the lines of:
lstBox_ChangeOption()
'code
end sub#
Shuld b able to do a similar thing in Excel IIRC
**EDIT***
Soz, then use
Select Case lstBox
6014 3DMk 05Originally Posted by Errr...me
Sorry, I'm totally crap with Visual Basic should I have something like this?:
Sub Larder2()
'
Select Case lstBox("Larder Prep")
Sheets("Larder Prep").Select
Select Case 2ndBox("Bakery")
Sheets("Bakery").Select
End Sub
To try and make myself clearer, I'm trying to create a worksheet to catalogue food supplies, with each spreadsheet containing information on each type of food. On the main spreadsheet I've created a few text boxes for data entry and a command button to copy them to a spreadsheet. I need to be able to select the food type from the drop-down list so that it can go to a specified sheet.
Last edited by jbp20717; 01-07-2005 at 03:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)