in a 'user form' I am trying to give a text selection a numerical value so i can perform a calculation with it elsewhere, my combo box has 10 entries held in a range (resourceTime) on a separate worksheet lets say ".5 day","1 day", "2 Day"etc.. When the combo box selection is "0.5 Day" i need to...
Hi There. I have a combobox which I populated with a two dimensional array.
Sub Test()
With ComboBox1
.List = DisplayArray
End With
Textbox1 = ComboBox1.Value
End Sub
The textbox value now just contains the value in the first column of the array (the array only has 2...
Hi
I have a table with 3 columns: Products, Location and Quantity. I created a userform to add new products and the code runs fine. Still, I would like my userform to do the following:
-if someone tries to add a product and that product exist in different location, I would like to view those...
I've developed a user form that's been operational for a while now but needs a change. One of the fields is a text box where users manually type the facility where a particular piece of inventory comes from. I'd like to change that input field to a combo box where users can select from a list...
I have a combobox on my worksheet and the listfillrange points to some data else where on the sheet. But when I try to set the text or value property, I get an error, "Could not set the Text property. Invalid property value" I'm comparing the properties of this combobox with another same...
Hello folks :)
I have the following code :
Private Sub CommandButton1_Click()
Dim strcon As String
Dim LastRow As Long
strcpycb = ComboBox1.Text
strcpytb = TextBox1.Text
strcon = strcpycb & strcpytb
MsgBox (strcon) 'for testing whether concatenation takes place correctly
LastRow =...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.