Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default ComboBox Update Question

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 135
Default ComboBox Update Question

On Feb 20, 11:33*am, Mullie21
wrote:
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox update Justin[_14_] Excel Programming 2 September 7th 06 05:17 PM
ComboBox Update [email protected] Excel Programming 2 September 6th 06 12:54 PM
Update combobox Aaron Excel Programming 1 April 4th 06 02:48 AM
combobox update Alex Excel Programming 2 September 14th 05 05:25 PM
combobox update Josh[_9_] Excel Programming 2 February 24th 04 05:22 PM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"