me.combobox1.value

Hello, I have the below code that have the purpose to update information in an already exiting database based on the TARA # in ComboBox1. This TARA # is the first column (A) in my workbook "TARADatabase). When I run the code, it gives me error 13 mismatch in the line i made bold in the code...

I have ComboBox1 and CheckBox1 Private Sub UserForm_Initialize() With Me.ComboBox1 .Clear .ColumnCount = 3 .ColumnWidths = "50;0;0" .AddItem "Hi" .AddItem "Bye" .AddItem "See Ya" .Column(1, 0) = 1 .Column(1, 1) = 2 .Column(1, 2) = 3...

Good Day Ma'am/Sir. May I ask for help. I cant find a way to display my Header Name in my worksheet in to my listbox un userform, even though i set to true the value of columnhead properties, it only displays cell values. I just want to also appear the header names in the listbox. Here is...

Good Day Ma'am/Sir. I am making a code for which i have a worksheet 2columns Dates,Sales. I want to make a userform which i can choose years in combobox and display and sum all the sales within each month in the list box. I manage to find a tutorial but it has some minor issue. it display only...

below is the code i have so far. It works to bring the data from the userform to the sheet i want but it starts it in row 2. I want it to start in row 17. Private Sub CommandButton1_Click() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("OUC_Vistana") Dim n As Long n = sh.Range("A" &...

Hi All, I'm relatively new to VBA, and by no means a coder, so apologies in advance for any VBA/coding illiteracy in the following. Using an amalgamation of online code and trial and error, I have created (almost) a data entry form that allows me to add entries to a worksheet. The form...

Hello and thank you for any attention my post may receive. There are two fields on my userform which are the focus of this process - ComboBox1 and TextBox1. ComboBox1 contains Accountable Leader roles. The code is assigned to TextBox1 - upon exit of TextBox1 the code triggers and validates...

Dear All, Userform1 : Combobox1 - Which shows different country list. "Country A, Country B, Country C, Country D, Country E, Country F, Country G, Country H & Country I" Combobox2 - Which is required to show the Start Time + 1 Hour, based on selection from combobox1. Now, For each countries...

Hi, I have a formula here which works but is not so handy. I dont want for example create a new userform for every day in Januari as you can se that I have done here. Is there a way to create a code to do the same thing with only one userform and a shorter code? If Not...