python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - userform

Change . to , decimal number userform entry on vba

I have a create a Userform VBA EXCEL asking an Exchange Rare value, the entry comes (for example) 1.25, but Excel don't recognized as number. So as soon as I tried a calculation on new cell, the error...
test-img

MarkuS_AureliuS

excel

vba

decimal

userform

Votes: 0

Answers: 0

VBA UserForm Issue - Could not set the list property. Invalid property array index

The below code works as long as there are more than one instance of the search criteria. However, if there is only one row that is listed as the what in the find function I receive the error "Co...
test-img

TDorman

excel

vba

userform

listproperty

Votes: 0

Answers: 1

Latest Answer

When your range contains one cell, the .value will give you a value instead of an array. As the .list expects an array you could fill an array with one element or use addItem (see below) If Worksheets...
test-img

EvR

Copying data from List to UserForm VBA

I am wondering if anyone could help me with this. I have written vba code to achieve goal when i click on "Button1" macro button in my sheet1 to open userform2 with a searchbox(TextBox) one...
test-img

AlexG

excel

vba

userform

Votes: 0

Answers: 1

Latest Answer

Add another column to the Listbox and use column 0 to store the row number for the record. You can set column width to 0 to hide. Add a label to the UserForm33 to store the row number on the spreadshe...
test-img

CDP1802

close excel application with VBa

I have written a small programm that consists of several userforms that are being called by each other. That means that if I press a button on Userform A, this Userform A closes and Userform B appears...
test-img

Jonas Walcher

vba

userform

Votes: 0

Answers: 2

Latest Answer

In the absence of any line of code displayed by you. I imagined a small example for you. See Step 1 & Step 2 and try to do it with your VBA code and let me know.. Private Sub cmdLeaveExcel_Click()...
test-img

Mohamad TAGHLOBI

Posts

Questions

Blogs

Jobs