Cacoethes
New Member
- Joined
- Jun 18, 2020
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Using Excel 2016 with Windows 8.1 Pro
Hello, I need some help. I must be missing something simple, because this works using Textbox values. When I use it as a dropdown list in a Combobox, it won't send until I close the UserFrom? My formula is Worksheets("Data").Range("B16") = Round_Cobo When I choose a dropdown Integer number from "Round_Cobo_Change(), It will not send the dropdown Value to the Worksheets("Data").Range("B16") until I close the UserForm, then it sends the last pick I chose. I need it to send the data when ever the Round_Cobo Dropdown changes.
I've tried making Round_Cobo a variable (Integer) then sent the Value with no change! I've tried placing ".Value" after it and no change. The Worksheet cell it's going to is set up as "General". I've tried as much as I can think of and obviously missing something?
If it's due to it being a Combobox (which I can't see why), then how do I correct this. Any variables needed are set up as Public!
Any help would be appreciated... I tried doing searches on your site but nothing I found helped my situation.
Hello, I need some help. I must be missing something simple, because this works using Textbox values. When I use it as a dropdown list in a Combobox, it won't send until I close the UserFrom? My formula is Worksheets("Data").Range("B16") = Round_Cobo When I choose a dropdown Integer number from "Round_Cobo_Change(), It will not send the dropdown Value to the Worksheets("Data").Range("B16") until I close the UserForm, then it sends the last pick I chose. I need it to send the data when ever the Round_Cobo Dropdown changes.
I've tried making Round_Cobo a variable (Integer) then sent the Value with no change! I've tried placing ".Value" after it and no change. The Worksheet cell it's going to is set up as "General". I've tried as much as I can think of and obviously missing something?
If it's due to it being a Combobox (which I can't see why), then how do I correct this. Any variables needed are set up as Public!
Any help would be appreciated... I tried doing searches on your site but nothing I found helped my situation.
VBA Code:
Private Sub Round_Cobo_Change()
' Any change in choice of pan size
'----- Record Diameter chosen to Worksheet Data B16 ------------
[B]Worksheets("Data").Range("B16") = Round_Cobo[/B]
Call Show_Middle_Column
'----- Show option button to see Calories or not --------------------------
If (CaloriesT > 0) Then
NoCaloriesEntered_txtbox.Visible = False
Calories_cmd.Visible = True
Else
Calories_cmd.Visible = False
NoCaloriesEntered_txtbox.Visible = True
End If
Call Show_Custom_Slice_Option
'----- Make Combobox Highlight move to next choice -----------------
'Servings_Round.Controls(WidthNo_Slice_cobo.TabIndex).SetFocus
If (RoundChange = 5) Then
Call Calories_Column_Calculations
If (SomeVw > 0) Then
Call Show_Right_Col_Custom_Slice
Call CustSlice_Calories_Calculations
End If
End If
End Sub