user form

I have a user form that I can choose a surname, then it displays up to 5 members of family if there are 5, but I cannot get it to save when I press the Edit and save button. Getting error (when I open or choose a surname) Subscript out of range memberRowIndices(memberIndex + 2) = f.Row '...

Hello. I need to create a UserForm template, which includes 5 images, these images will eventually have pdf pictures loaded. I will then need to creating about 30+ UserForms from this template, i can do this manually by importing the template and renaming it, and I know i can then go into each...

First off my data is simple- five columns Manufacturer, Type, Description, Function, Category I need to create a user form that allows the user to select Manufacturer and Function from a drop down list. Once they choose manufacturer and function, I need the vlookup to provide all of the valid...

I am trying to take the values passed from a userform that has the following checkbox options and write them to a single concatenated cell. Thank you for your help. Any suggestions would be greatly appreciated. I currently have attempted this, but can only get one option to show up at a time...

Current Issue: So far, however, I have (with assistance) created a user form in Excel that collects data and inputs it into a spreadsheet, which can then be exported to a PDF report using a set format/layout on another sheet of the workbook. The layout consists of a "Header" section and an...

My program is a material cost estimator: In cells D14 through D38 and D42 through 99 I need to add values using a User Form. For this example, cell D20 is selected, and it has a value of 100' of drywall. I am adding another room so I want to press + that will bring up my User Form that will...

I've done some research on combo boxes and list boxes and userforms and I feel a little out of my depth at this point as I cannot recreate this form as I need it and I'm sure it's a lot easier than I'm making it out to be. I am not opposed to creating the form in a new method and I would greatly...

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

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

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

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

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

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

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

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

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

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

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

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

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