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

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

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