Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with ComboBoxes.
Hi, I'm experiencing some difficulty with the ComboBox macro. It works correctly when I put it into the document (saving the document poses no problems). After I close the program and then reopen it, I have to go into each and every combobox and run it again! How can I avoid having to do this each time? Thanks, Rosemary -- rosemary ------------------------------------------------------------------------ rosemary's Profile: http://www.excelforum.com/member.php...o&userid=25042 View this thread: http://www.excelforum.com/showthread...hreadid=385658 |
#2
|
|||
|
|||
Private Sub ComboBox1_Change() ComboBox1.List = Array("1", "2", "3", "4", "5+") End Sub Thanks! -- rosemary ------------------------------------------------------------------------ rosemary's Profile: http://www.excelforum.com/member.php...o&userid=25042 View this thread: http://www.excelforum.com/showthread...hreadid=385658 |
#3
|
|||
|
|||
Didn't you reply to a different thread that you had the solution?
rosemary wrote: Hi, I'm experiencing some difficulty with the ComboBox macro. It works correctly when I put it into the document (saving the document poses no problems). After I close the program and then reopen it, I have to go into each and every combobox and run it again! How can I avoid having to do this each time? Thanks, Rosemary -- rosemary ------------------------------------------------------------------------ rosemary's Profile: http://www.excelforum.com/member.php...o&userid=25042 View this thread: http://www.excelforum.com/showthread...hreadid=385658 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Comboboxes & Textboxes | New Users to Excel | |||
Getting combobox dropdowns to appear on a userform when tabbed to. | Excel Discussion (Misc queries) |