userform buttons

Hi I have tried to search and made several attempts (that all failed). I have a Userform with a script that works. I have a command button to submit onto the spreadsheet which all works. I have found that the person using the form is missing some fields such as month and dept. I want to add a...

have the following code in my user form which uses a class module (not shown). It all works great, but I want to add the buttons dynamically according to a list in my worksheet and don't know how to use an array to dimension them. At the top of my user form I Dim the events references: Dim cbe1...

Hi all, Novice VBA user here. I'm a structural engineer and working to create a program that helps evaluate the demands on a pile foundation group. So far, it has two user forms - the first form asks the user how many piles the group contains, and then a "next" or "cancel" button. When the...

is it possible to search by date range and the result will show in textboxes without using datagrid/listbox? i have two rows of 3 textboxes first row should show only the result for the first person, and in the second row of textboxes will show only the result for second person. if date person...

I have a userform with checkboxes that push a yes or no into another sheet that drives the model. The problem is the code is bogging down and taking too long to refresh. Does anyone have an easier way to loop through all the checkboxes on the userform and push the yes / no into the cells? Below...

I'm very new to VBA and this is probably simple, but I can't get it to work for me. I need Two ENTER BUTTONS that will run the same code. · I've created a very LONG Userform. · I'd like an ENTER Button on both the TOP and the BOTTOM of the userform. It's more...

Hi there, I've currently got two spreadsheets; 1) AOK Form (v2) - [This spreadsheet will be stored locally for over 100 users individually] This is where the form is located and it serves no other purpose than opening the form (there is a hidden sheet for lookup lists for combo boxes) 2)...

Trying to get my userform to behave properly. Have two option buttons in frame but I want them to be unavailable unless Checkbox value is true. Based on my research so far, what I have should work but alas it does not. I am still very green with VBA and could use some help. Public Sub...

Hi, I made a user form consisting of a Command Button "Browse". When a user clicks on it, a dialog box appears to search for a folder. Now when a folder is selected, I want that the Name of all the Files inside that selected Folder should be copied in my excel sheet. I tried coding for the same...

I'm currently working on small macro that can be used to autofill empty cells with certain formula, and I have two questions: I create UserForm to input the data on the desired worksheet. I have assigned column A and E:AM for the input, and leave cloumn B:D empty. In the data entry, I have...

So I have a userform that populates a table, but I would really like two things added to my userform. First, I'd like it to be able to move between the entries via "prev" and "next" buttons. Then I'd like a way to open a specific entry of data. Anyone have suggestions or ideas of how to go...

Hi All, I have two problems which hopefully have the same solution. I have a template which I have created for a large user group, the template is password protected. Problem 1. When the user opens the template I have a macro which clears everything in the work sheet so that the user has a...

I am really very new to VBA USERFORM Codes and I need to create a database file that would have a lot of data. I was able to create a file that can add and data input to the DataBase sheet. I also have codes how to generate reports for different sheets. However, there are still buttons I need to...