userform

  1. P

    Excel Userform question (passing values and lookup)

    Hi, I'm looking for some guidance.. I've got the following setup: (1) A userform which acts as a search interface (2) A useform which 'should' show the individual record details selected in (1) The source data is in a table and I can successfully pass the correct table row number to the...
  2. lockarde

    Exporting Userform design and code to import in VB

    Hello all, I've recently created a userform within excel to take care of some quick calculations I regularly have to do. After getting it all set, I thought, why not make it a stand alone app, instead of having to run excel everytime? I tried exporting the userform, and I get two files, one...
  3. TAPS_MikeDion

    Need to pass one variable to another form, but it's not passing the value.

    Hi everybody, Even after looking over examples found on the forum I still can't seem to get this super simple thing to work. I'm obviously missing something small. I have a main userform that has a "GET CLIENT INFO" button which opens a small userform displaying the client information, but I...
  4. A

    Code link optionbutton ,compobox with textbox and cells in sheet

    hi, expert i would help finding code connect the data sheet with optionbutton , compobox and textbox in userform for explanation i have data in sheet1 in columns c,d are two prices price the column b is the brand and userform 2 optionbuttons and compobox1, textbox1 here when i choose the...
  5. P

    If userform is already open then MSG box to open saying Userform in Use

    Hi I am trying to put a code together into a command button which opens the userform1, but if someone else has the userform open already I want a msgbox pop up to say that ‘userform is in use’, I have put the following code togetherbut getting no joy. Hope you can help? Private Sub...
  6. L

    Userform Listbox Row Source

    Hi all I have a table displaying in my userform listbox I have set the rowsource to the table name (dossier) but it does not show the table headers, is there a way I can do this? This is the line of code: UserForm1.lstdisplay.RowSource = "Dossier" Also if I get this to display will it remain...
  7. J

    asking for ideas

    any idea on how to make labels in userform look like a button ?
  8. J

    Change format of userform textbox to currency

    Hi there, I have a userform with 4 textboxes that when text is entered they all refer back to individual cells. All data entered on a spreadsheet goes to the userform and when entered into the userform goes back to the spreadsheet. One of the textboxes displays a price but i cant seem to change...
  9. S

    Userform UPDATE record and date issue

    Hi guys need help with vba code for userform Cells formated to date dd/mm/yyyy and use the isdate etc on userform....and if not a valid date wont accept....but noticed entering 07/12/18 will go into cell as 12/07/18...frustrating Also managed to get update button to update data with addition of...
  10. S

    VBA auto refresh cell value in userform - textbox.

    Hello, I created a form whose value could be edited via userform. in same userform, there is a cell that shows the result of that calculation. how to make it dynamic? 'Diğer değişkenler için burayı planladımPrivate Sub tbBINR_Change() Select Case tbBINR Case "<1,7" X = 1...
  11. I

    Is it possible to link Excel UserForm to OneNote?

    Hello, I've created a UserForm in excel and I'd like the userform to appear on my teams OneNote notebook. Does anyone know how to do this? Or if it's even possible? Thanks,
  12. N

    linking combobox value with VLOOKUP to a textbox in userform

    Hello, I have a sheet "Clients" that contains all clients details as the table below and I have all these data as dynamic named range "Client_Details" "A2:D4" I have a userform with many text boxes and combo boxes, but what I need right now is: Once I choose a Client name in the combobox1...
  13. E

    Populate userform textbox with date taken from cell in 'dd/MM/yyyy' format

    Hello, I want to fill a userform textbox with a date taken from a cell. The date in the cell is in 'dd/MM/yyyy' but the date drawn from this cell into the textbox comes always as 'MM/dd/yyyy'. Any suggestions would be highly appreciated as I have been wasting tons of hours on that issue...
  14. P

    UserForm data to Worksheet and Save

    Hi all, Good day! I would like to ask for your assistance on this project that I am working. I have a UserForm that goes like this: I have a code in place in the 'Save Form' button that transfer the data from the UserForm to the Worksheet in the same file. The data is entered from Cell B9 to...
  15. A

    Ticking checkbox to link in other sheet

    Hi Guys, Please help me on my project. I am creating an inventory/monitoring form that I have a multiple checkbox on my userform and when when i tick the checkbox1 it will automatically go on that particular sheet. I made a simple program like this. Sheets("Apple").Visible =...
  16. J

    Creating TreeView in UserForm

    Hi, I am looking for any geniuses that can help me make a TreeView in Userform. There are barely any tutorials online, and I still have no idea on how to make them. I provided a picture below of what kind of TreeView that I want and the table database sample. Also, I would like to have the...
  17. D

    UserForm within Macro

    I am constructing a macro to perform sorting on different selected named ranges provided by a user form which has a combo box and I do not know what best practice is: Call the user form from within the macro or call the macro from the user form. I would appreciate any advice and...
  18. I

    Clear cell contents THEN close userform

    Afternoon. I have a worksheet called HONDA SHEET which has a drop down list in cell A2 When i make a selection from the list my userform called HondaSoldItems is shown & values etc shown. Now what i would like to happen is when i press my close button on the form "NOT the red cross" cell A2...
  19. C

    Vlookup On A Userform With Textboxes

    Hi, I want to use vlookup in userform textbox,below code is working in current workbook. Private Sub TextBox1_Change()TextBox48.Value = Application.WorksheetFunction.VLookup(CLng(TextBox1.Text), Worksheets("product").Range("a2:d100"), 4, False) End Sub But i want to use with closed workbook...
  20. J

    Objects not visible in multipage userform while in edit mode

    Excel VBA beginner I've prepared a userform with a two tab multipage area. I added several labels, textboxes and combo boxes within the first page but had not yet started any code work. I clicked outside the multipage form to edit some other objects and now I am unable to see the multipage tabs...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top