userforms

Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are the issue. Typically during testing , the userforms are loaded and unloaded a ton of times...

After hours of searching for this topic with not much success, I thought I'd ask the question here. I have a giant spreadsheet that contains many formulas, Excel tables and other references. In order to make it more user-friendly, I decided to create the Userforms to centralize all the data...

I'd like to be able to delete VBA code when a macro is actioned, including userforms etc... And if possible delete a protected sheet Is this possible?

Greetings, I have 10 userforms - lets call them userforms1 and userform2 and userform3 and so on. And I would like in certain circumstances for these forms to be able to call a second userform that we will call userformA. However, I need to pass information from at least 1 textbox into a...

Hello Everyone, I am currently working in an internship where I must create excel VBA userforms, intended for clients. In these userforms, there are comboboxes and textboxes all which correctly transfer responses into an excel sheet. However, I have multiple “multiple selection” list boxes in...

Hello, I am trying to create a userform for a database that repeats information in rows as I enter other information like Category and Amount. As an example, see below table: <tbody> Project (CC1) Funding Agency Grant Name (CC3) Contract Number Start Date End Date Status Category (Account)...

Hi All you clever people. I'm looking for a solution to my userform validation issues. I have 8 textboxes 6 of which need to be numerically validated, the other 2 do not. My problem is that I can get the numerical validation to work however it forces the 2 textboxes I don't want validated to be...

Hi all I have a textbox called Reg1 on a userform and i want to exit sub when certain numbers or unique IDs are in it and i still click the back button. The numbers are started with texts like wkx1001 , wkx2001, wkx3001 up to wkx52001. Adding 52 if statements is too long i think. So i have...

Hi there, I currently have a worksheet labelled "Register". I have this code whereby it extracts the worksheet and provides the 'save as' option to a folder. The worksheet has headers and filters. The columns: O-U are labelled as follows: Column O: Marston Green Column P: Test Engineering...

Greetings everyone. I'm running a series of forms, combining several information for my company, among them a system that generates graphs for monthly deliveries. Since the userform does not support graphs, the alternative I found was for the macro to save them as .gif files which are loaded by...

Hello and thanks for looking on a Userform in Initialize I would like the label boxes to change color based on the cell value in Column F Values would be "Day Shift", "NIGHT SHIFT", or an emtpy cell or stay the same back color as the userform if there is nothing in column F Cells where the...

I have a worksheet for creating and storing purchase orders. I have several different sheets and the main 'front page' sheet with command buttons. The command buttons are linked with userforms that are working perfectly, and inputting data into the appropriate sheet where and when I want...

The excel document that I am working on has several worksheets that show and hold different data. When others review this information I would like to have a consistent navigation bar that stays present for quick and controlled page changes. I have searching the net for days and the most...

Hey there, new to the forum. Been working on an excel project and I am having some difficulty figuring out how to go about what I need to do. What I am trying to build is a program that lets a user select various options as they build a vehicle. And by selecting one engine, it grays out all...

Hello (to be short), I'm creating a custom (Usercontrol (ocx)) Userforms for excel, the name is Virtual forms. (Not to bother with the details, you can read about it in the Lounge v.2.0 here in MrExcel forums...

Hi Guys, I'm having a problem deleting Rows in the spreadsheet from a Command Button titled "Remove". In short, I want to select an item from a list box within a userform and then click the "Remove" button to delete that row. Unfortunately after executing the command, "Run-time error '1004'...

(Excel 2010 - 32 Bit on Windows 7 Enterprise) Hello, I ask for your assistance with transferring data between an Excel Sheet and a userform. The userform is intended to both capture (write to an Excel sheet) and retrieve (from the same Excel sheet). My problem is that, when I debug the code...

I'm new to forms, so I have two basic questions that I can't find the answer to. 1) I have a form Report_All_Specific that asks users if they want to run a report for all employees or specific employees. The form consists of a question and two command buttons named All_Active and Specific. I...

Dear Mr. Excel, I've searched quite a bit but can't find the appropriate search term to zero in on the answer, or it just can't be done. (Never!) I am designing a form that needs a variable number of ScrollBars. I need to generate scrollbars from within a loop, so that there is 1 scrollbar...

Hi there, I've tried searching of ways to do this but have not found a way. I'm fairly new to VBA too, so please be patient if this has already something you've broken your heads over :) Your help would be much appreciated! The problem: I have data for over 100 headers, so when it comes to...