me.combobox1.value

  1. S

    Mismatch Error VBA Excel

    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...
  2. S

    Change Userform Combobox Value from Combobox Column after additem has occurred

    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...
  3. B

    Worksheet HEADER not display in LISTBOX

    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...
  4. B

    SUMIFs of SALES IN LISTBOX/COMBOBOX

    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...
  5. C

    Data from userform to cells

    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" &...
  6. C

    Data Entry Form : VBA Run-time Error '91': Object Variable not set with ws.cells.find function

    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...
  7. N

    Userform Change Focus On Field Exit

    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...
  8. R

    Excel Userform :: Time Combobox

    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...
  9. M

    Simplify formula

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top