Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

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

  1. #1
    Guest

    Default

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

  2. #2
    Guest

    Default

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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you not change the name of one of them?

  4. #4
    Guest

    Default

    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.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Guest

    Default

    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?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •