Hi, Good morning all,
So, simple question : Is it possible to refer to a userform objects like a ListBox from a macro example :
The userform code could be :
And the macro code would be :
Private Sub CommandButton1_Click() call module1.Test End Sub
Sub test If Listbox1.text = "blabla" then etc... End Sub
Yes, you could do it a couple of ways, you could either create custom properties.
something like this in the form
then reference,Public Property Get ListBox1Value() as variant ListBox1Value=me.listbox1.value end propertyor you can just open the form into an object and reference the object frm.listbox1.value.UserForm1.Listbox1Value
I am not in Excel at the mo, so cant properly test, but i'll post back in about 30mins.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Yes, you could do it a couple of ways, you could either create custom properties.
something like this in the form
then reference,Public Property Get ListBox1Value() as variant ListBox1Value=me.listbox1.value end propertyor you can just open the form into an object and reference the object frm.listbox1.value.UserForm1.Listbox1Value
I am not in Excel at the mo, so cant properly test, but i'll post back in about 30mins.
Yes, I tried just stating the userform name before the object and it works.
Ex :
Thank you for your help.If UserForm1.ListBox1.Text = "Blabla" then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks