ComboBox Update Question

M

Mullie21

I'm using a ComboBox that is populated with a list of values (say 0,1,2,3).
If I want to update the '0' to an 'A', how do I do this? How do I update one
value within the combobox LOV?

Any help is much appreciated.
 
M

meh2030

I'm using a ComboBox that is populated with a list of values (say 0,1,2,3).  
If I want to update the '0' to an 'A', how do I do this?  How do I update one
value within the combobox LOV?

Any help is much appreciated.

If the combo box is on a UserForm, then you'll need to see the code
that is in Private Sub UserForm_Initialize() for the respective
UserForm. For example you might have the following:

Private Sub UserForm_Initialize()
cmbBox.AddItem 0
cmbBox.AddItem 1
End Sub

You can alter this code by changing the 0 to "A" and so on. If you
have a combo box on a spreadsheet, find the range that the combo box
is referencing and change those range inputs.

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top