combobox1.value

I try to open my UserForm and for some reason it is erroring saying permission denied... Any ideas? Error says it has to do with worksheet code line 'UserForm1.Show' I have very similar issue to this guy here... We used the same tutorial and wanted our program to allow more than just the first...

Hello, Is it possible to populate datas inside cells(starts from K2) instead of listbox with the given sample below code? Private Sub CommandButton1_Click() Dim r As Long, Ac As Long, c As Long If ComboBox1.Value <> -1 And ComboBox2.Value <> -1 Then ListBox1.Clear With...

I have combobox13 and textbox14 that reflects the combobox13 selection. I have another combobox1 and when I select "D18", Combobox13 uses a named field from my spreadsheet. If anything else is selected it uses a different defined field. However, I need it to first clear out what is in the...

Hi Guys, Dont understand what wrong here.. Private Sub ComboBox1_Change() If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _ Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting"...

Hi All, Can anyone help me in below code, to rectify it. Something went wrong in logic. Situation is, when selecting "Core", submit not happened and when select "Non-Core", submit works. Also, if on any place we can minimize the code, please do guide / help.. Private Sub btnsubmit_Click()...

I am attempting to build an interactive document where users can pick from a drop down and a display would show up based on the item picked from the drop down. Sub ComboBox1_Change() ‘this would be the drop down menu for the user to choose from. With ComboBox1 .AddItem "AA" .AddItem...