excel & userform

  1. B

    VBA - Mark cell with Email Sent

    Hello all, I have created a user from that is automatically checking for out of date dates and automatically creating the emails and currently displaying them before being sent. I need to be able to mark the next empty cell as 'Email Sent' to indicate that the email has been sent for that...
  2. J

    Dependent Comboboxes

    Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...
  3. J

    Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    Hello! I have a userform with two sections. There are 4 checkboxes in each section with the idea that they will be pre-populated comments that will fill into a textbox. I am able to get it to populate text into the textbox when one box is checked however the way I have it written only allows for...
  4. J

    Excel Userform - Check specific textboxes to ensure that only one in each section has a value entered

    Hello! I have a userform which will be used to complete audits on employee work. There are 2 sections which will be audited with 1 of 3 possible responses (Yes, No, N/A). As the auditor completes the form they are pressing a button (Images - Thumbs Up, Down or N/A) which will populate a text...
  5. P

    Multiplying Textbox Value

    I have the below code that works: Private Sub CommandButton1_Click() Dim cell As Range For Each cell In Range("I2:I2") cell.Formula = Replace(cell.Formula, "100,", TextBox1.Value + ",") cell.Formula = Replace(cell.Formula, "260000000000,", TextBox2.Value + ",") Next cell End Sub But, I would...
  6. C

    open ppt from sharepoint using the File path in VBA

    Hello, I need to open PPT file form SharePoint using the Excel VAB, can any one please help me how to do it.:confused::confused::confused:
  7. B

    VB Get the last 3 digit number

    Hi guys i have a problem about my userform i have 16 textbox and command button to search in textbox 1. is it possible to search only the last 3 digit number in textbox1 instead of 8? here is my code for my command button :):):) Dim totRows As Long, i As Long totRows =...
  8. W

    format excel vba texbox for numers instead of text

    When sending data to a worksheet the record is transferred successfully but the all cells that contain numbers have the green triangle(formula error I am guessing) and cannot be formatted as well as the cells with dates also cannot be formatted. This in turn prohibits those rows to be included...
  9. N

    Display excel records on listbox based on selected value from the combobox

    Hey guys, am a newbie to VBA programming... And at work am developing a userform for the excel spreadsheet. The spreadsheet tracks the operation of the tractor, its attributes include date, opening and closing mileage, fueled on. Now on my userform i have a combobox populated with months and i...
  10. M

    Importing images into userform

    Hi, I have a multi page user form that I am using to predict scores for the premier league soccer fixtures each week. Within each page I have 1 fixture made up of a home team and an away team. This data changes week on week depending on the a web import. I want to add two images to each page...
  11. M

    Create an Excel VBA form using a loop to source the inputs

    Hi, I have a list of soccer games on sheet "Web Import" with team A in column C and team B in column E. I want to create a user from for a user to input scores for these games. So when the user form pops up (once the spreadsheet is opened) it should present the user with the teams from the...
  12. E

    excel vba printpage are different values then on userform

    hi all when i print my userform listbox the values of 1 column change to a different value can someone tell me what i did wrong ? screenshot of what i want to print http://prntscr.com/keph0g code of printing Private Sub OUprint1() Me.Hide Dim rng As Range, wks As Worksheet, ListData() '...
  13. C

    Using UserForms to Make Letters that Pull Data from SQL or Oracle

    Greetings Folks, I'm probably not in the right area but I have an idea that will make my job and the job of my peers 100000x's easier. I was considering sitting down and redoing all the letters we send customers using UserForms or using Excel, somehow and googling until I figured out how to...
  14. C

    DTPicker

    Hello all you lovely people. Just a quick question, I have a userform that has a DTPicker (Calendar Date Picker) in it that shows today's date, how do I make it display the day before. Thank you in advance.
  15. H

    Editable vlookup value

    Hi Team, I have this vlookup code that I've been using. It is giving me the result that I need. However, I want the vlookup result to be editable. To be more specific with the problem, Whenever I choose a value from combobox1 then a corresponding value will appear in textbox1 however, I want...
  16. V

    Adding new record when trying to update thru 'update command button' in userform

    Hello Everybody, I have created a USERFORM which has command buttons namely CLEAR, ADD, SEARCH, UPDATE, DELETE, PRINT, CLOSE. All commands are functioning except UPDATE BUTTON. When I am searching a record through combo box, search result is perfect. But after making some changes in the record...
  17. JonnyAngelo

    Filtering data into a userform listbox

    Hi! Apologies for a bit of a nooby thread, I'm super new to VBA. Simply put, I have created this userform and want it to show data within a listbox in the userform. The data I have is stored on a worksheet and I want the listbox to also list new data once added to the worksheet. The filtered...
  18. J

    Run a specific userform from Modules

    Hi all, I would like to run a userForm with a specific name from a Module. Here is the code for my userForm. Public Sub UserForm_Initialize() 'Adding the Options for fileDecision comboBox With fileDecision .AddItem "Append" .AddItem "Copy" End With...
  19. D

    Exel UserForm ComboBox list from a table column

    Newbie to VB and I'm struggling to find a code to complete the above. I have a UserForm for with 2 combobox's, the first is for category ("cmbCat") and the second for supplier ("cmbSup"). I would like to be able to upon initializing the form list data from "Table5[Category]" on worksheet...
  20. S

    Excel User Form_ List Box Macro

    Hi All, I need you help with the Listbox in Userform, I have two columns in Excel Raw file, Column A has got categories and B has got the unique data. I want to have all the Data from Column B in the list box, which falls in the category (From Column A) mentioned in TextBox1. kindly assist...

We've detected that you are using an adblocker.

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.
Go back
Back
Top