Results 1 to 6 of 6

Use sheetname to open a Userform

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2004
    Posts
    18

    Use sheetname to open a Userform

    Hi

    I want to Show a different Userform based on the sheet its opened from. I have tried code below but the UserForm name is in the wrong format but can’t find the correct Dim, can anyone help please? The target Userform is ‘cables_form’.

    Snippet:-

    Tried both of these:-
    Dim form_name As String
    Dim form_name As UserForm
    
       sheet_name = ActiveSheet.name
       form_name = sheet_name & "_form"
       form_name.Show
    I am using Excel 2000

    Andrew
    Last edited by mudraker; 08-01-2007 at 07:24 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1