userform Questions
5
I created an Ms-Access userform which has a number of Textboxes. The boxes are named: Box1, Box2, Box3 ...
I need to loop through all boxes, but I don't know which is the last one. To avoid looping...
4
Solved
In my UserForm, I want to set a default value for my TextBox, that will highlight when focused upon.
Private Sub UserForm_Initialize()
NameTextBox.Value = "Your Name Here"
NameTextBox.SetFocus
...
5
I'm having a very strange issue with Excel UserForms; when I display a form by clicking a command button in my worksheet, the size of the form warps significantly, making it essentially unusable. T...
6
Solved
My Excel UserForms contain a variety of objects, including text boxes, combo boxes, radio buttons, etc. The UserForm and the objects on the UserForm shrink and expand when my laptop is on a docking...
4
Solved
The UserForm which is controlled by another controller complains on console as
"Warning: A component is changing an uncontrolled input to be controlled. This is likely caused by the value cha...
Punchy asked 23/10, 2021 at 16:52
7
Solved
I'm using a userForm in vba and I have a list box. I want to remove the horoz. scroll bar from the bottom. Is there a way to do this? I don't see any option in the properties box.
2
Solved
In a UserForm I've got multiple listboxes.
A list of all Groups in the Active Directory (AD);
A list of selected Groups from ListBox1;
A list of unique members (hence the use of a dictionary since...
Photogene asked 9/12, 2022 at 14:10
3
I searched for this online for a while, and I did find a few solutions, but none of them appear to help me.
I have a Userform in Excel 2010, which I would like to center on the Excel window. I hav...
3
I have read and applied solution I found on similar topics but nothing seem to work in my case.
So, I want to pass a variable from one sub of my Module1 to a userform. It's a string called "provi...
2
Solved
I have made a userform in Excel and saved it. Every now and then when I open up the editor, the form has been resized by itself. When I click in the bottom right corner of the form to resize it, it...
2
Preambule
When trying to position a UserForm at a particular Pixel position (stored in a POINTAPI Type structure), one must convert the Pixel coordinates to Point coordinates to be able to set the...
6
Solved
I have a simple user form with a button on it. I want to pass this form to a function in another module - but even inside the same module, it does not work as expected:
Private Sub Test(ByRef oFor...
4
Solved
I'm very new with VBA Excel and i only know the things as far as i need for this report formatting task.
I'm almost done with my task but when i run the program and start the progress, eventhough ...
2
Solved
I have a textbox and a listbox on userform. I want to filter the values in listbox based on the value I enter in Textbox. Sheet named TMP has the values and I filter it based on textbox change even...
4
Solved
I have a vba code thats Auto_Open. It does some checks then prompts a userform that asks for username and password. I called this userform with userform_name.show.
My issue is how can I return a B...
Hearten asked 23/9, 2013 at 18:21
3
Solved
I need to create labels and buttons dynamically and then add them to a frame within a userform. How do I do this? Seems like it should be easier than it really is.
6
Solved
I have an Excel userform with dynamically added checkboxes.
I add the checkboxes with code that looks like this:
Set chkBox = Me.Controls.Add("Forms.Checkbox.1", "Checkbox" & i)
I want to r...
11
Solved
When showing a userform (running its Show method) it not only shows up on the screen but also takes the focus (the destination of e.g. keystrokes).
Say, the userform is a custom made toolbar. Its ...
3
Solved
Is there anyway to have a userform that acts modeless, while still pausing code execution like a modal form?
I'd like the userform to show, but still allow interaction with the parent program. Mod...
Yvetteyvon asked 31/5, 2013 at 13:57
0
Context
I've written some code in VBA to subclass a userform so that ultimately I can intercept WM_TIMER messages being dispatched to it. I'm doing this instead of specifying a TIMERPROC, as it all...
3
Solved
Just a question that I can't seem to find an answer on.
I'm programmatically creating a userform, and I've found if I declare my object as the type "MSForms.Userform" there seems to be no way to ...
3
Solved
I run a program which repeats itself. It should stop, when the user closes the userform. It runs without stopping.
Since the program calls itself every 8 seconds, I want to check at the end if the...
3
Solved
I'd like to learn a new trick, but I'm not 100% confident it is possible in VBA, but I thought I'd check with the gurus here.
What I'd like to do is eschew the good-old getopenfilename or browser ...
Akiko asked 13/12, 2013 at 15:22
7
Solved
I have a userform containing lots of text boxes. When ever the values of these text boxes changes, I need to recalculate my end result values based on the textbox values by calling a subroutine Aut...
Graupel asked 9/5, 2011 at 17:53
2
Solved
Suppose I have this following code in my EXCEL VBA UserForm:
Private Sub TextBox_Change()
TextBox.Value = UCase(TextBox.Value)
OtherText.Value = "FOO " & TextBox.value & " BAR"
End Sub
...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.