Most voted "userform" questions
A customizable graphical interface that interacts easily with VBA when working with Microsoft Office products.
Learn more…12 questions
Sort by count of
-
2
votes2
answers2141
viewsUSERFORM: What is the difference between Initialize and Activate routines?
What’s the difference in using Initialize and Activate as a Userform boot routine? Private Sub UserForm_Initialize() Private Sub UserForm_Activate()…
-
1
votes2
answers792
viewsUSERFORM: I can’t remove items from my Listbox (Error 80004005)
I have a Listbox in a Userform that I "reconstruct" based on a Textbox that I use as a filter. The idea is to bring all items to the list with Rowsource and remove all items that do not contain…
-
1
votes2
answers224
viewsCheck the end of the song and run macro
Hello, I am making a virtual sound table for an event and would like to give the effect of clicking the button. I am making mega simple, but I need the button to be pressed while the music plays and…
-
1
votes1
answer1287
viewsCorrect formatting for excel vba time
Good afternoon! I’m finding a problem that I thought was basic but that I couldn’t solve. I have a Userform (Entradas) to register entries. These entries are played to my spreadsheet in Excel. In my…
-
0
votes1
answer604
viewsConcatenate Userform text and insert as link in a cell
I’m trying to feed a table with 3 information inserted from the execution of a Userform and, at the end, make a direct hyperlink in the cell with the information inserted. The information is as…
-
0
votes0
answers344
viewsUSERFORM: Move Listbox item up or down
I have a Listbox in a Userform that reflects a list of the order of display of the items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in…
-
0
votes1
answer1926
viewsCount the number of selected items in a Listbox
I have a list ListBox1 in a userform configured for multiple item selection. There is some function, statement, or way to return the number of selected items?
-
0
votes1
answer3790
viewsCheck if a Listbox item has been selected
I have a list ListBox1 q a check box ChckBox1 in a Userform. I want to activate or inactivate the checkbox (CheckBox1.Enabled = True/False if an item in the list is selected. The check-box is…
-
0
votes0
answers37
viewsDoubt about Excel textbox control
You guys, good night! Reason for my coming here: I have a Textbox control in an Excel Form (VBA). This form is configured to accept line breaks with ENTER and multiline. However, when sending this…
-
0
votes1
answer983
viewsThe Value method of the Range object failed
Good evening, I’m making the following mistake: The Value method of the Range object failed The complete code is found here: By the Ghostbin Private Sub CommandButton2_Click() ''' Botão "CADASTRAR"…
-
0
votes1
answer66
viewsListing in chronological order | Visual Basic
Good afternoon, how do I order the times chronologically without affecting the dates in excel, using Visual Basic? I have a spreadsheet where are saved the entries I do by VBA. In column G are the…
-
0
votes1
answer36
viewsHow to check dates past their expiration date?
I created this Sub to process the data of my listview. However, the first part of my If is not working properly: .ListViewEntradas.ListItems(i).ListSubItems(7) < Date. I would like to leave in…