userforms

So I am trying to create a button that opens a userform thatasks questions on what the user wants to do. It is kind of hard to explain so Iam going to try to insert screen shots of what I want to happen. Below is part of a table that is created on the main pageentitled “Status Sheet.” <tbody>...

Hello Experts, Is there a way to import UserForms (located in separate folder) when I open Excel file ? Workbook_Open method can help but I'm not sure as how to call the Forms from that. Your help is greatly appreciated ! Thanks.

Hi there, Hope someone will be able to assist me I have a button that will copy one sheet and then create a new sheet with the copied content. Then the userform will also popup The userform then needs to add the content to the newly created sheet. I don't seem to get it to work Here is what I...

I am having issues passing information between userforms and I have tried asking how to do this here but I think I was asking the wrong questions. Here is my quandry. I have numerous UserForms that utilize data created on another UserForm but I can't seem to get it to recognize the data so I...

Hi - Is there a way to have a message box pop up when the macro starts to run that just says please be patient? I've tried UserForms, but they stall the macro until you close them. Thanks!

There I was... knee deep in open Chrome tabs with more VBA code than I could handle... I'd been lost out there for hours with no solution in sight... nothing but hours old coffee to quench my thirst... I tell myself "it's okay to ask for help... someone probably knows how to do this." "Never...

Hey community, Can anyone help me to make commandbutton to open userforms second page? not first page

Hi, Im looking for help, i have 5 userforms which are all linked to the same spreadsheet. The spreadsheet is to log Non-Conformances. The reference number will start with "NC0001" and then go up sequentially. The userforms are labelled Part1, Part2 to Part5. Everytime i enter details on the...

Good afternoon all! What I am trying to achieve is this: - User opens Workbook A - User clicks a button to open Workbook B so they can edit it (B is password protected, it can only be opened in write mode from book A; this is supposed to 'force' users to only use book A (and its userforms) to...

Hello I have a userform dumping data into an excel table. I'd like for a user to be able to select their name and have a list of their records populate in a record ID combo box. I wrote the following code that seems to almost be doing what I need, except that it is pulling all of the record...

I'm just starting to learn Excel VBA, after using excel for the past 5 years. I've been learning how to create Userforms first as it seems like a good way to understand simple VBA logic and language. I created a userform and spreadsheet for myself for a budget tracker. I've seen people...

All, I downloaded a prepackaged template off the office 365 site and am having some trouble modifying the macro to apply the color shade formatting and text formatting associated with the userforms "Toggle Task Complete" & "Select Task Priority" Ideally i would like to be able to apply the...

Hello everyone, Was curious if there is a way to call the windows 10 touch keyboards in userforms when clicking on textboxes, toggle buttons, command buttons etc.. Both the full keyboard and the numeric keypad. Had some older userform keyboard forms/modules from looking into this same thing...

Hi all, Is there a way to change already activated (displayed) UserForm's position on the screen? Thank you in advance

I am attempting to teach myself how to do userforms I can draw them and get the code behind them but I am struggling to pull everything together . If I describe what I need could someone please help out I have 7 tick boxes on a USER FROM lined up named CEA,HAV,ENT,MENIGO,PHM,PCP,RNASEp and one...

Hi Peeps, I need some help please. I have created an excel sheet with userforms in it. One of the userforms, asks for 6 sets of numbers. Total Hours Physiotherapy Occupational Therapy SALT Dietetics Psychology It's used to track therapy costs. What I wanted to do was that if the total of the...

I have managed to populate a combobox on userform from a column in a table with unique items (to remove duplicates.) I want to do the same with several other comboboxes with items from other columns in the same table. What do I need to do to the code to make this work. as duplicating some of the...

Hi MrExcel, I have this mini-project where I plan to make a website simulator (offline) by means of screenshots/pictures. I achieve below by making transparent labels and added codes like on the labels: Me.Hide UserForm(number).Show (the project is made up of over 20-30 UserForms at...

Hey there, Below is a snippet of code that I use to send email from my userforms for a variety of functions. And I use this code in hundreds of userforms and macros. During a corporate audit this morning the question was asked of me of who will be maintaining the code in a few years when I...

Hello I've been around the woodwork with this one, so hopefully I haven't gone totally off track. Got the feeling I'm straying into the OO problems of VBA/VB6... Desired Outcome: Creating (no more than 2 at any one time) multiple instances of the same Userform, at runTime, and then referring...