Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
On a userform, a combobox with choices 1 through 10. I have the control
source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. So I have to click on some other control, or close the form. I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. Can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
You can use the combobox change event:
Private Sub ComboBox1_Change() Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value End Sub hth Carlo On Dec 21, 1:57*pm, Charlie wrote: On a userform, a combobox with choices 1 through 10. *I have the control source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. *So I have to click on some other control, or close the form. *I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. *Can this be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
Do I just put this private sub on a seperate module? Do I call this sub from
the form or the combobox1 to make it work? Or do I replace the control source of this combobox with something? Thanks. "carlo" wrote: You can use the combobox change event: Private Sub ComboBox1_Change() Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value End Sub hth Carlo On Dec 21, 1:57 pm, Charlie wrote: On a userform, a combobox with choices 1 through 10. I have the control source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. So I have to click on some other control, or close the form. I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. Can this be done? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
Sorry didn't make myself clear.
In the vb-editor, double click on your combobox, that should open the code of your userform, and following lines should be displayed now: Private Sub ComboBox1_Change() End Sub Although ComboBox1 could be slightly different depending on the name you gave your ComboBox. between those lines you can now enter this: Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value Don't forget to adjust the names of the sheet and the range and the combobox1 otherwise it won't work. hope that was a little clearer Carlo On Dec 21, 2:30*pm, Charlie wrote: Do I just put this private sub on a seperate module? *Do I call this sub from the form or the combobox1 to make it work? *Or do I replace the control source of this combobox with something? * Thanks. "carlo" wrote: You can use the combobox change event: Private Sub ComboBox1_Change() * * Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value End Sub hth Carlo On Dec 21, 1:57 pm, Charlie wrote: On a userform, a combobox with choices 1 through 10. *I have the control source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. *So I have to click on some other control, or close the form. *I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. *Can this be done?- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
Ah, Great! I'm beginning to understand where all this different code goes!
thanks. "carlo" wrote: Sorry didn't make myself clear. In the vb-editor, double click on your combobox, that should open the code of your userform, and following lines should be displayed now: Private Sub ComboBox1_Change() End Sub Although ComboBox1 could be slightly different depending on the name you gave your ComboBox. between those lines you can now enter this: Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value Don't forget to adjust the names of the sheet and the range and the combobox1 otherwise it won't work. hope that was a little clearer Carlo On Dec 21, 2:30 pm, Charlie wrote: Do I just put this private sub on a seperate module? Do I call this sub from the form or the combobox1 to make it work? Or do I replace the control source of this combobox with something? Thanks. "carlo" wrote: You can use the combobox change event: Private Sub ComboBox1_Change() Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value End Sub hth Carlo On Dec 21, 1:57 pm, Charlie wrote: On a userform, a combobox with choices 1 through 10. I have the control source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. So I have to click on some other control, or close the form. I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. Can this be done?- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
You're welcome
if you have any other question, just ask. It takes a while until you get you're head around stuff like that. There are some good tutorials on the web, that you might want to check out. Cheers Carlo On Dec 21, 3:28*pm, Charlie wrote: Ah, Great! *I'm beginning to understand where all this different code goes! thanks. "carlo" wrote: Sorry didn't make myself clear. In the vb-editor, double click on your combobox, that should open the code of your userform, and following lines should be displayed now: Private Sub ComboBox1_Change() End Sub Although ComboBox1 could be slightly different depending on the name you gave your ComboBox. between those lines you can now enter this: * * Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value Don't forget to adjust the names of the sheet and the range and the combobox1 otherwise it won't work. hope that was a little clearer Carlo On Dec 21, 2:30 pm, Charlie wrote: Do I just put this private sub on a seperate module? *Do I call this sub from the form or the combobox1 to make it work? *Or do I replace the control source of this combobox with something? * Thanks. "carlo" wrote: You can use the combobox change event: Private Sub ComboBox1_Change() * * Worksheets("sheet1").Range("a10") = Me.ComboBox1.Value End Sub hth Carlo On Dec 21, 1:57 pm, Charlie wrote: On a userform, a combobox with choices 1 through 10. *I have the control source set to sheet1!A10, but in the field A10, nothing happens until I leave the focus from the combobox. *So I have to click on some other control, or close the form. *I need my chooice from the combobox to take affect immiedately, because it affects others controls on the form. *Can this be done?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
....There are some good tutorials on the web, that you might want to check
out. ....any in particular you'd recomend? thanks. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox data doesn't take affect right away
Hi Charlie
try to enter "excel userform tutorial" in google. The first page will get you at least 8 good tutorials. hth Carlo On Dec 25, 10:34*am, Charlie wrote: ...There are some good tutorials on the web, that you might want to check out. ...any in particular you'd recomend? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does structure of data affect speed of vlookup? | Excel Worksheet Functions | |||
How does 1 value affect the average? | Excel Worksheet Functions | |||
Will importing tab-delimited, extra, data affect attributes/formatting in prepared XL2K file? | Excel Programming | |||
How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions |