PC Review


Reply
Thread Tools Rate Thread

Copy Value from ComboBox to Cell

 
 
Tim Duell
Guest
Posts: n/a
 
      30th Nov 2006
When I set boundcolumn to 0 the code will work, but the value of the
combobox will not stay when file is saved and reopened. When I say value I
mean the text displayed in the box. When bound column is set to 1 the code
will not work, or does not have the desired outcome, No information shows up
in cell E4, but the value, text displayed, will not stay when file is saved
and reopened. What am I doing wrong?

Private Sub ComboBox10_Change()

If ComboBox10.Value = 0 Then
Range("e4").Value = " "
ElseIf ComboBox10.Value = 1 Then
Range("e4").Value = "Urgent"
ElseIf ComboBox10.Value = 2 Then
Range("e4").Value = "Routine"
End If

End Sub

Thanks so much for all the help.

Tim Duell
Buckeye Shapeform


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy From Combobox to Cell Tim Duell Microsoft Excel Programming 3 4th Dec 2006 03:45 PM
Copy Value from ComboBox to Cell Tim Duell Microsoft Excel Programming 5 28th Nov 2006 11:07 AM
how do I copy from textbox or combobox into a cell Peterke Microsoft Excel Programming 1 24th Jul 2005 02:00 PM
copy combobox - cell link to change automatically =?Utf-8?B?Qm9qYW5h?= Microsoft Excel Worksheet Functions 1 8th Jun 2005 02:35 PM
Control Combobox Linked Cell vs Forms Combobox Linked Cell RamblinWreck Microsoft Excel Misc 2 26th Mar 2004 03:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:01 PM.