visual basic excel list box?

Question

How can i have a box that pops up on the screen asking you to select one of the following. Have a list of options you select one and it pastes that value into a cell? I have been halfway through the internet and I'm starting to believe that its as impossible as seeting a cell format to all CAPS.

Answer 1

This is not exactly what you want but it may show you how to do what you want.

Good luck.

Answer 2

Insert a command button, in the code type "Userform1.show"
Then make a new userform and draw a Combobox and a command button on it. Type in the following code:
Private Sub CommandButton1_Click()
Sheet1.Cells.Range("a1").Value = ComboBox1.SelText
End Sub

Private Sub UserForm_Initialize()
ComboBox1.AddItem "hello"
End Sub

In the userform_initialize section, copy and paste the code and create your own items. for example:
combobox1.additem = "new item"
and change the cell value to what ever you want.
As for the case change, just enter the formula "=UPPER("text here")

Answer 3

I spent hours looking for the same thing and I'm afraid that I came to the conclusion that you can't.