Results 1 to 6 of 6

Use sheetname to open a Userform

Threaded View

aph Use sheetname to open a... 08-01-2007, 04:49 AM
royUK Follow the Forum Rules & wrap... 08-01-2007, 07:22 AM
aph Hi Roy The workbook has 4... 08-01-2007, 07:59 AM
royUK here's one way Option... 08-01-2007, 01:57 PM
aph Hi I tried your suggestion... 08-02-2007, 03:11 AM
royUK The Select case is correct,... 08-02-2007, 03:19 AM
  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