combobox1 values

[Todd Huttenstine]

I have a combox1 on userform1. How do I get it to where when you click the
down arrow on the combobox it displays values? I want the combobox when
clicked to have 4 choices: New, Rebuilt, Used, and Upgrade.


Thanx in advance.

Todd

 

[Dave Peterson]

You've got a reply in .programming.

It's probably not a good idea to cross post your messages. If you really think
that you have to send it to multiple groups (I don't think it's necessary), put
all the newsgroups in the header and send one message.

 

[Vasant Nanavati]

Hi Todd:

You can list the values in a vertical range and then use the range address
as the RowSource property of the ComboBox.

Regards,

Vasant.

 

[Dave Peterson]

I meant multiposting is a bad idea. Crossposting (multiple newsgroup headers in
a single message) does make some people upset, though.