Questions tagged [userform]
A customizable GUI that interfaces easily with VBA when working with Microsoft Office products.
userform
3,118
questions
0
votes
1
answer
50
views
Making a mini-calendar in vba with userform
I'm working on a mini-calendar that is poping up when I click on a date in excel. The mini-calendar is made of userform. When I click on a date in the calendar, it transcribes it in the cell. ...
1
vote
1
answer
19
views
Excel Code running twice unintendedly when A checkbox is added to Chain code together
I have a few blocks of codes, made to assist a user to automate defect capturing. I have a userform, and that form has a listbox called ScreeningDefectList. I have a button called Fail and a box ...
-2
votes
0
answers
26
views
How to create automatic code in userform VBA? [closed]
I'm doing an inventory userform. I need to create an automatic code for each item that is registered. Say, Item 1 - P0001, Item 2 - P0002, and so on. I've tried adding a string "P" to the ...
0
votes
2
answers
32
views
After loading a userform, the first click on a listbox does not select the clicked item
After loading a userform, the first click on a listbox does not always result in the clicked item being selected. It seems to take 1 click to first wake-up the listbox and a 2nd click to start ...
-1
votes
0
answers
36
views
VBA Userform embedded in a frame (container) on another userform or on a multipage control
All, I have developed several tools for members of my team. Each of these is driven by an icon on the outlook ribbon that simply calls a routine in a standard module. All this does is show the ...
0
votes
0
answers
26
views
Textbox focus moving strangely in multipage VBA Userforms
I have a multipage form that I want to use for setup for a data analysis macro. I want some textboxes to show a warning label if the user exits them without entering a valid value, so I used the ...
0
votes
1
answer
63
views
Text jumps left when zooming UserForm in VBA
I have a user form and in order to get the form in full screen mode I have this lines on the initialize:
Application.WindowState = xlMaximized
UserForm.Zoom=Int(Application.width/UserForm.width*100)
...
1
vote
1
answer
44
views
How to force textbox exit event when closing a userform
I have a userform with input textboxes. I need to force validation on the textboxes, which I use the Exit event to do. The issue I have is that someone can enter data into one of the textboxes and ...
0
votes
1
answer
47
views
VBA - Wanted: Getting UserForm Object giving its name
is it possible to have a function getting given a string indicating an Object's name then returning corresponding UserForm Object as a result?
Function foo(name as string) as Object
dim Obj as ...
0
votes
1
answer
61
views
Create 2D-Array with a user form TextBoxes
I would like to create an array from the userform input of the TextBoxes. However, I get an error message (Type mismatch (Error 13)) when I want to convert the values from the userform TextBox into ...
-1
votes
1
answer
58
views
Call sub from userform leads to error "not defined"
I have done this before and have no idea why it is not working. I am in Outlook VBA and have a userform with a button, that is supposed to call a public sub:
Option Explicit
Private Sub ...
0
votes
1
answer
40
views
Data transfer into multiple sheets from userform
Am new to vba and am trying to transfer data into activesheet/sh.name by activating the sheet but getting error. I also need a code to display the list of months in a combox.
thank you for your ...
0
votes
0
answers
15
views
Purchase Order in a VBA Form
I am interested in creating a UserForm designed for generating purchase/customer orders. The UserForm contains two Parent-Child frames. In the Child section, I would like to add several TextBoxes for ...
0
votes
0
answers
19
views
c# Unable to Auto Size all Combo Box Dropdown Column Widths on Windows Form
I have written the two below methods to auto size the dropdown widths of all the combo boxes on a windows form. However, it doesn't appear to be hitting any of the combo boxes. When I apply the method ...
0
votes
1
answer
16
views
Why won't my UserForm text field not update programmatically?
I'm writing VBA in Microstation and I want to populate a text field PathToScan with the active design file's path, which is ActiveDesignFile.Path.
What I'm currently attempting has worked just moments ...