userform

Hi there, I have a VBA Userform, when the command button is pressed the data inserted into the UserForm needs to be placed in specific cells within the workbook. Sheet name - Sheet3 (Template) Textbox1 to B5 and C59 Textbox2 to D59 Textbox3 to C62 Textbox4 to D62 Textbox5 to D7 Textbox6 to F7...

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...

I have an userform that users toggle buttons to that will make text boxes appear if toggled but I have issues passing the date if two toggle boxes are pressed for example toggle box1 = true then 2 text boxes will appear where users will put data in toggle box2= true then 2 text boxes will...

I am creating a userform for my organization which has multipage controls on it, and many controls within each multipage. I had been working on getting the userform completed until I ran into an "Out of memory" error. This happens on a fresh restart of my computer and with no other programs...

Hi all, I'm brand new to VBA, so I'm trying my best but I could definitely use some help on this one. I have a listbox of 5 items with the ability to select multiple items from the listbox. However, I want when you click on an item in the listbox for a textbox to appear relating to that...

Howdy, I am new to VBA and am looking for some help with a macro. A bit of the background, i am building myself a monthly budget spreadsheet to keep track of expenses and income. I trying to code a button that i can add a expense for a month to a table within a specific worksheet which...

Hello, I am creating a userform where depending on which option selected in the combobox different ranges should be selected. The ranges are taken from a long list with columns from A to E. A is filled with dates. It looks something like this: If i am choosing option "Hello" in the combobox...

Good morning all, I'm using the typical method of using a window handle to re-activate an instance that launched a userform. However, I need to run the FindWindow routine from every control in order for it to work. I have well over 200 controls in the multi-page userform, and it will be...

Hi I've just started using a ListBox in Excel to view a table from one sheet on another. I've been able to do this using very simple code as Private Sub UserForm_Initialize() Me.ListBox1.List = Worksheets("Cashflows").Range("A4:H26").Value End Sub However, as this does not include...

I'm currently putting together a simple data reporting tool. Part of it is a UserForm for selecting parameters for applying filtering to the data. The UserForm has a ComboBox (loaded_cols_combo_box), three TextBoxes(cutoff_fraction_textbox, skip_n_textbox, max_range_sz_textbox), and two...

Hey, I have a user form that I have Enable multiLine "True". I Have a text box that I would like to have the Output to sheet1: A2 A3 A4 A5 - - - - A150

I have an userform with two Comboboxes and a textbox. Combobox1 has a string of time slots. The selection of combobox1 should define in which row the data from textbox1 is put. Combobox2 is populated by the same text as columns B to I, the selection should define in which column the data from...

I am working on creating a wellness and physical fitness dashboard and understand how I can create a Userform using VBA to add/edit a single record but am wondering if it is possible to add multiple records when entering groups of like data (Body Msmts, Hematology, Cardivascular, Chemistry...

Hello, Im wondering if someone can help me. I want to setup a userform in a way that i need 2 conditions to fullfilled to show a value in a textbox. In other terms, if my car model is A and its power is B, i need the price C to show up automatically in the price textbox. And i prefer to fill...

Hi Folks, Excel Max has helped me understand a useful way to link option button choices in a userform to a Case SELECT inside my vba code. This code takes the choice of option box and returns it when the ActiveOption function is called from the userform code. Function ActiveOption() vA =...

Hi All, I have a button that leads to a UserForm where the User enters in some information and is prompted with an InputBox. The intention is that the user types in the row that they want the aforementioned UserForm information to be placed. I seem to be struggling with transferring the row...

Hi guys, I am looking for VBA code to look in column A for a certain = ComboBox value and when finds to check row number, move it from sheet1 to sheet2

Hello, I am a noob to VBA, but I am finding it very interesting. I've watched a bunch of tutorials, but still cant come to a solution to my problem. I have a stock take/Inventory list I am in the process of making. Basically I have multiple datasheets for instance: DatasheetBeers, DatasheetWine...

A very interesting post a while back from user Herve and replies by Jon Peltier and Richie(UK) talked about initializing a userform from a general module but keeping it hidden so the value could be passed back to the general module...

Hi everyone, I am trying to make a userform where each sheet has its own corresponding checkbox. The goal is to print the selected sheets into a pdf upon clicking OK button. I have managed to somewhat achieve my goal. But it feels like it is far from being optimal. I had to assign 2...