How can i refer to two UserForms with same name in Workbooks

Mar 13th, 2002, 06:50 AM

Can you suggest a way? The two userforms UserForm1 are in different Workbooks but both are open.

Mar 13th, 2002, 08:13 AM

pls help
I have tried to find answer from VBA help, but failed.

Audiojoe · Mar 13th, 2002, 08:16 AM

Can you not change the name of one of them?

Mar 13th, 2002, 08:27 AM

So you mean almost no way to do so? I have thought of that after i spent much time on the help files. But ... it is a problem of referring to userform when there are multiple ones.

Audiojoe · Mar 13th, 2002, 08:29 AM

Well I don't know if it's impossible or not, to be honest it's not something I've ever looked into, but when I had the same situation a little while ago, I just changed the name of one of them to Userform11

I'm sure it's possible though, just a shame that no-one here seems to know

Mar 13th, 2002, 08:31 AM

Also i found that the controls in a UserForm is not so easy to handle.
My codes such as
ComboBox1.RowSource = "'Sheet1'!AA1:AA" & lastUsedRow
ComboBox1.Value = Range("AA" & lastUsedRow).value

cannot work. I also tried to use With...End With
The userForm rowSource is not changed at all. Why?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 06:50 AM	#1
Guest Posts: n/a	Can you suggest a way? The two userforms UserForm1 are in different Workbooks but both are open.

Mar 13th, 2002, 08:13 AM	#2
Guest Posts: n/a	pls help I have tried to find answer from VBA help, but failed.

Mar 13th, 2002, 08:16 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Can you not change the name of one of them?

Mar 13th, 2002, 08:27 AM	#4
Guest Posts: n/a	So you mean almost no way to do so? I have thought of that after i spent much time on the help files. But ... it is a problem of referring to userform when there are multiple ones.

Mar 13th, 2002, 08:29 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Well I don't know if it's impossible or not, to be honest it's not something I've ever looked into, but when I had the same situation a little while ago, I just changed the name of one of them to Userform11 I'm sure it's possible though, just a shame that no-one here seems to know

Mar 13th, 2002, 08:31 AM	#6
Guest Posts: n/a	Also i found that the controls in a UserForm is not so easy to handle. My codes such as ComboBox1.RowSource = "'Sheet1'!AA1:AA" & lastUsedRow ComboBox1.Value = Range("AA" & lastUsedRow).value cannot work. I also tried to use With...End With The userForm rowSource is not changed at all. Why?