userform

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...

I found the following code that provides the function I need (sorry, I forgot to snag contributor's name). Private Sub txtPriCO1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case vbKey0 To vbKey9, vbKeyBack, vbKeyClear, vbKeyDelete, _ vbKeyLeft...

Hi I presently have the following: Private Sub CommandButton1_Click() Dim TargetRow As Integer Dim FullName As String 'full name Dim xRg As Range Dim xCell As Range Dim i As Long Dim J As Long Dim k As Long Sheets("Staffing-Processes").Range("Ref").Offset(TargetRow, 28).Value = TextBox24...

Hi out there, my project is about creating userforms based on the values in a worksheet. People planning their USFs in advance or work with templates can accelerate the setup in a smart way. The code to create this both items is: ' the objects are declared as VBComponent Set mdl =...

I have a userform (frmMatrix) where the user enters the current Heat Index and Population of Interest and is returned with a statement of recommended protective measures. Next, they are asked if they would like to make a record of these protective measures in my Data Entry form (frmForm). Upon...

Hi all, so recently I've made some changes to a .xlsm Excel file and then digitally signed it. I then opened the .xlsm Excel file and saved [CTRL + S] immediately without doing anything. An error message saying that "You have modified a signed project. You do not have the correct key to sign...

Hello, I have what is supposed to be a simple problem with dynamic Checkbox. I'm making a list CheckBox in UserForm. Dim chkbox As MSForms.CheckBox Dim i As Integer For i = 1 To 3 Set chkbox = Me.Controls.Add("Forms.Checkbox.1", "Checkbox_" & i) chkbox.Caption = "Test " & i...

Through use of multiple UserForms I open a 2nd workbook that I hide and then may get or write data to that workbook before closing it. All was good until I noticed that when the red X in upper right corner (Close event) of forms was clicked that the 2nd workbook was left open and hidden. To...