user form

  1. M

    One Userform button to fill in TWO separate tables

    Hey guys, first post here but I have been a follower/reader for quite a while. I currently have a userform that enters into whatever table you double clicked on (Userform opens on double click). It will populate that current table properly no issues. I want it to populate the same...
  2. K

    Row Range Problem In User Form?

    Hi ! I have built a user form to enter data of my field of Radish in point of Sales Record. The form is working good and entering the values correctly by these codes. But I have put some charts and additional data in my excel sheet upper rows. User form enters the value at the 2nd top row and...
  3. T

    64 bit MouseWheel hook for pointer xy on a User Form, key press and wheel rotation

    I have 32 bit routine that hooks into the Mouse wheel event and returns the x y position of the mouse pointer on a User Form plus the direction of the wheel rotation and a value for any key pressed while rolling. (Code that I can find on this site and on the web generally only returns the...
  4. J

    Displaying information

    Hello, Probably this is a very silly question, but I need some help I have a form which was working well, showing me this information In my excel sheet, Id was column 1, Name colum 2 and Last Name was Column 3. This is the code that I had: With Worksheets("Registers") filas =...
  5. J

    Range question

    Hi, I have a question, I hope I can explain my self clearly I have a form called userform1, this form is to show information about people , I can find them by id or by name, I can modify information from that form. As you can see, beside volunteer name box, there are two search buttons, if you...
  6. K

    User Form Button disappeared from Home menu.

    I had a programmer crank out some vba for me that essentially allowed the user to go to the Home menu, click a custom button called "Import Folder Files". Once they clicked this icon, a form would popup and ask them to identify the folder that contained the files you wanted imported. User then...
  7. J

    Save Emails from Excel

    Hi There, I have a new specific problem with interacting with outlook. I have a sheet where I need to save approval for things that came via email. I will be using a userform to allow my users to select which row the approval should go in. I need the macro to look at the user's inbox (there...
  8. C

    Show worksheet range of cells in a user form

    I would like some help finishing the VBA code that I'm trying to piece together. I have 2 ranges of cells in a worksheet ("Data") that I would like to show individually (not at the same time) on a user form while working on another worksheet ("Input") within the same workbook. The user form...
  9. S

    Using Option Button to Set Variable

    I've got a command button that prints my workbook to a PDF with a specified filename and location, but I've been asked to add the option to save to one of two folders (without being able to browse to other folders). I'm trying to use a user form to choose the folder name, save it as a string...
  10. B

    GoTo Function in VBA checking values

    Can anyone help with the following, I am trying to miss the email module when checking through my code, I want the to skip this part of the code: Call EmailOutOfDate (Email, ExpDate, Documents, Days Remaining) and check a value in the cell which determines whether or not an email should be...
  11. 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...
  12. S

    VBA User Form : Reference Value should come based on Button Click

    Hi Friends, I have a VBA User Form consisting of 1 button and 2 textbox. When i press this button , the value of button is coming in the textbox1. Till this part i have completed. Private Sub button1_Click() If button1.Value = False Then TextBox1.SelText = ComboBox1.Text + " " Else...
  13. G

    VBA UserForm - Using TextBox to look up in a range

    I have a userform that when it runs comes up with a blank text box. I want the user to be able to type in the value that they want to lookup, in this case it is a box size, and once they press enter I need it to put all the matching information on the same sheet that I have my macro button that...
  14. A

    Search function to find customer

    I am just learning how to create VBA's and need some help please! I have a worksheet that I am using to manage customer information. In rows "E" trough "T" are the fields for customer information such as customer name, address, phone,etc. I have over 1500 rows of information to keep track of. I...
  15. dannyok90

    Notes Userforms

    hi all, I'm thinking of creating a user form to help me track notes and checking. I'm not a novice with VBA and user forms butequally im not a master and maybe not quite an intermediary user either haha. Basically i have spreadsheet sheet for estimating jobs. It has rows representing subtasks...
  16. B

    Show Cell Values in User Form- VBA

    I have a workbook with 26 worksheets that could have data in a certain range of cells. What I'm hoping to have is a subroutine in a user form that will look at each sheet in a range of cells V5:Y39 and show a list with no blank rows in a user form. I will have a Button on each sheet that will...
  17. N

    User Form Text box number to Excel

    Hi all, Apologies for the terrible title. I have a user form where the user enters the total number of hours they were at work for. In most cases it is 7 and everything is fine, however, for part time staff, when they enter 5.5 and click the submit button, the data that gets published to excel...
  18. M

    Have existing button! Can I add existing buttons to New User Form???

    Obviously new to VBA. I've created spreadsheet with many buttons and text boxes, etc... Now, I realize I should have placed them on a User Form for better control. Is this even possible? Can I add existing buttons to a new user form? I've searched the internet and especially your site for the...
  19. D

    TextBox export back to worksheet as number (%)

    Hi, I have got very difficult issue for me and cannot handle it myself :-( Hope experts here can help me. First of all I need to say that I am not good in VB, I am doing sth only from time to time only using hints and manuals. Now I did sth which is very helpful for me, a user form which...
  20. D

    textbox macro object required error

    Good morning Everyone. I am creating a macro where users put something in a textbox, and it turns green after someone checks it. all i needed was for the textbox to turn green, but when i put in the code, it says object required. Sub Jira()ActiveSheet.Shapes("TextBox25").Select...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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