user forms

I have a checkbox in a userform Is it possible to run a sub on checking the checkbox and a different sub on unchecking? I have only seen the syntax for running on click eg: Private Sub CheckBox1_Click() If not i will have to use buttons instead, but thought a checkbox would be more elegant Thanks

I have a user form which places data into rows on a spreadsheet. Once the data is in there I would like to have another user form which can be used to change that data and replace the old data. The original form consists of text boxes, combo boxes, check boxes and option buttons as well as...

Hi guys, I have created a userform where I have a combo box and an options box. I want the combo box to reference a specific list of values. And if the check box is selected, I want the same combo box to reference a different list of values. This is the present syntax I am using. For some...

I have a Userform that has 2 radio buttons. Depending on the selection updates the worksheet automaticlly. It also has a textbox that I need to be updated with the cell that the radio buttons are linked to. That much I have completed. My problem now is that I need to be able to edit the text box...

I have written a simple macro to allow me to GoalSeek over a range instead of a single cell (requiring that the values all be goalseeked to zero variance). It's been a long time since I have worked with forms, however, and there is a lot I don't recall. At this point, I have the main macro...

Hi, I have a little routine that is supposed to test that duplication does not occur. Problem is that if I use tbPPCode_Click the user may bypass it by using tab keys. If I use tbPPCode_Change the event triggers on the second key pressed. How can I force this routine to wait untill the client...

The title says it all ... I have an idea how I would like it to work but have no clue how to start .... I have a report sheet that contains the final data. The export sheet is used to input data into that report sheet. The user who will be responsible for collating the input data has very...

Hi, I have created a form with 40 checkboxes and each one relates to a column. When the user clicks the command button on the form i want the code to check if checkbox value is true and if so delete column. The only way i can think of to do this is by writing 40 if statements and for each if...

All, I have a dynamic range serving as a RowSource for a list that populates a ComboBox in a userform. I only want the user to see the non-blank items in that range. I am also using the selection to run a application.match off of so I need to retain it to pre-populate some textboxes. How can...

Good afternoon! I am creating an excel user form. I'd like to use drop down lists and have become familiar with the combo box for this in the user form. however, what I would like is to get diminishing returns based on the selections, like filtering works on an excel sheet. A section of my data...

I am a VBA novice. I am trying to create a user form that performs a search and returns cell values (mostly text) from an excel spreadsheet that is not already open. The user form would have 1 box for the user to enter (type in) what they are looking for. They would then hit a search button...

Hello, I have a userform that I launch from a workbook that is used for non-technical users to make changes to said workbook. I want to have a "View Category Tree" button on the userform that, when clicked, will launch ANOTHER userform/window (MsgBox is too simple) that displays an outline of...

Hi Folks, A while back, one of the forum people created a VBA script for a searchable library database I had. I would like to take the same concept and put it in another workbook, but I just don't know how to code it. Can anyone help? I have attached the original coded spreadsheet (sorted...

I have just finished a fairly simple VB code to convert data sourced from a txt. file into a predefined format in order for it to be run through a secondary program. Currently I am simply pasting the data in the the first box and then running the macro, however I would like to create a user...

For a particular project, when a user logs in, a UserForm will appear for input on what procedures are needed from the Lab. The UserForm (frmInputProc) has 11 Check Boxes and a Text Box for Special Instructions. When the "Save Data" commandbutton is clicked, I would like Label from each...

I'm clueless - really. I was tasked with creating a user form that populates a spreadsheet. The trained person who was supposed to do this left the company abruptly. And so here I am... an English Lit major! I have created the form below by following various examples that I found online...

Greetings to all you señor Excels! I have an Excel sheet that has approximately 25 columns and a continuously growing number of rows as it serves as a simple database. What I'm trying to achieve is to have a Form Control button which upon pressing would pop up a window (user form) that would...

Hello all, I'm still working on my design problem: allowing (very non-technical) users to edit Excel data in a format that doesn't look like a spreadsheet. A User Form the same size as the Excel screen might work, but only if User Forms can pick up data from the source worksheet, allow users...