Questions tagged as 'userform'

Tagged questions
2
answers

USERFORM: What is the difference between the Initialize and Activate routines?

What's the difference between using Initialize and Activate as a userForm's boot routine? Private Sub UserForm_Initialize() Private Sub UserForm_Activate()
asked by 27.04.2017 / 19:23
2
answers

USERFORM: I can not remove items from my ListBox (Error 80004005)

I have a ListBox in a UserForm that "rebuilds" based on a TextBox that I use as a filter. The idea is to bring all the items to the list with RowSource and remove all items that do not contain text from the TextBox. However, when testing the sys...
asked by 11.04.2017 / 21:43
2
answers

Check the end of the song and run macro

Hello, I'm making a virtual sound table for an event and would like to give the click effect of the button. I'm doing mega simple, but I need the button to be pressed while the music plays and when it is finished the button will disappear. Yo...
asked by 20.06.2017 / 19:04
1
answer

The 'Value' method of the 'Range' object failed

Good night, I have the following error:    The 'Value' method of the 'Range' object failed The full code is here: GhostBin Hair PrivateSubCommandButton2_Click()'''Botão"CADASTRAR" código para inserir as informações fornecidas na pl...
asked by 20.11.2018 / 01:20
1
answer

Count the number of selected items in a ListBox

I have a ListBox1 list in a userform configured for multiple item selection. Is there a function, statement or way to return the number of selected items?     
asked by 27.04.2017 / 20:21
0
answers

Doubt about Excel textbox control

Everyone, 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 information to a javascript control it does not...
asked by 26.05.2018 / 04:25
0
answers

Userform as auth method not working Excel [closed]

Hey guys I think it's probably a very simple awnser but I'm not finding it. I made a simple user form that takes a user and a password and pops up before the workbook is visible as a simple auth method. The problem is that I want to hide the...
asked by 05.10.2017 / 23:42
1
answer

USERFORM: Move ListBox item up or down

I have a ListBox on a UserForm that reflects a list of the display order of 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 the ListBox, as shown in the figure: Is there a...
asked by 08.04.2017 / 14:40
1
answer

Concatenate Userform texts and insert as a link in a cell

I am trying to feed a table with 3 information entered from the execution of a Userform and, at the end, make a direct hyperlink in the cell with the information entered. The information is as follows: Path to a certain folder (textbox) Th...
asked by 25.03.2017 / 15:50
1
answer

Check if an item in a ListBox has been selected

I have a ListBox1 q list of a ChckBox1 checkbox in a UserForm. I want to enable or disable the checkbox ( CheckBox1.Enabled = True/False if any items in the list are selected. The checkbox is disabled initially, but if so...
asked by 27.04.2017 / 22:11