userform

I have a userform, and I am trying to get the data that is typed in the text boxes into certain cells on a new sheet in the same workbook. On Sheet Intro, I click the new entry button and I get a userform titled NewForm. The text box renamed NameBox, gets a users name entered into it. You then...

Hello, I feel very confused by this because I am still learning and trying to understand VBA with Userform. I have a worksheet where I would like specific data (Lab #) to be posted into another worksheet based on the Date entered. I will attach the an image (unfortunately my work does not...

I've attempted to modify API code found on another web page to resize userform in proportion or aspect ratio (Width/Height = constant). Did a fair amount of testing, it's a bit tricky to figure out sequence of code ... suggest that UserForm_Resize is called up before UserForm_Initialize ... and...

I have a spreadsheet from where I need to refer to about 20 diagrams. Was going to load each diagram onto a userform, because I need to read cells and diagram at the same time. The issue with images in forms is that the quality is not great, and difficult to read text in image. Was looking at...

Hello everyone. I have a page named data in listbox index 4. When I click on the data in the listbox, it should open that page. What is the vba code for this?

hello, I want the listbox rowsource to take the page name from the textbox! the a2:e50 part will not change. can you please help me with this... ListBox1.RowSource = "10001!a2:e50"

I have created a userform with 3 buttons, "Save as .XLSM", "Save as .PDF" and "Cancel" What I would like is for this command box to pop up when we go to save the document (click on save as > browse) The buttons work just fine every time someone hits Save as .PDF. BUT, it will only work once...

Hi Does anyone have any experience in using the UXTheme.dll visual styles to create 'modern' looking controls in the VBA Userform? I've been experimenting with it, and I've hit a wall of sorts - especially when it comes to the Textbox. I would be grateful for any guidance or recommended...

This is very useful code to resize userform dynamically, from Andy Pope. Anchor controls Is it possible to resize form, in steps or increments. In the vertical direction only. Say in increments of 24.

Hello all, I think this topic has been discussed in many posts here and other forums. I'm sorry for the Clickbait (for some), however, I was unable to solve my problem.... I have a workbook to register my expenses, so I have a Sheet for every month of the year: so, first sheet is for January...

I created a UserForm that stores 15 fields into a worksheet. This UserForm has functions like opens a ListBox with all the records, filter the records, edit the records, etc. When I run the UserForm everything is fine and it runs smoothly. But I'm having a problem that when my coworkers try to...

Is it possible to write to multiple textboxes at the same time. For example: 1. Select first text box (say TextBox2) 2. Something like: Hold "Shift" and select last text box (say TextBox7) 3. Write Number, say 9

Hello all, I am working on a monthly tracker for work where I have a userform that allows the user to enter data. My last goal with this is to select a month tab based on entered data in the userform. For context, right now I have to manually select the month I want to enter the data to, then...

Hello I have followed @Jaafar Tribak 's excellent work in Display Userform in TaskBar with custom Icon and Hide Excel (mimicking a standalone application) to make a userform that appears as a standalone application. It's connected to an instance of SolidWorks through its VBA api. By running the...

I would like to create an image slideshow that loops through all the images in all the subfolders in thisworkbook.path with a fade in effect for each image and a 5 second timer delay between each image in an excel userform. I searched in copilot and I have some code, but it currently gives me...

Hi All, I have been stuck thinking of a way to implement a "Sanitise Sheet" macro for one of my template and was hoping to crowdsource a couple of ideas. The mission, should you choose to accept, is to have a macro assigned to a button which creates a new .xslx file of a tab, which...

Hi all, long time lurker, first time posting. I'm new to VBA, but I've been able to build a couple of user forms for my company's benefits team. My form populates data using xlookup and populating textboxes based on the combo box selection is working well. However, I am having an issue...

Dear all, I've been trying to make a Userform which contains: - Textbox, used as search input - Search button - Load button (not coded yet) - Frame: - Checkboxes (dynamically made) - Scrollbar When I've used the search function, the scrollbar moves to the found value (image 2)...

Hello, I am a long time user of VBA but i never had the need to deal with userforms until recently i started digging into it. I have been following OOP lessons at university and as a rubberduck user (in the sense that i read a lot of the VBA advices given on the blog) i found more coherent the...

Please see the “Assignment 4” screencast for a detailed demonstration of what you are trying to create in this assignment. In the starter file, we have the seven dwarves and their phone numbers: Obviously, with so few records it would be easy just to edit the cells/spreadsheet directly...