+ Reply to Thread
Results 1 to 2 of 2

How to show a related Userform depending on the Active Cell value

  1. 09-02-2010, 08:29 PM #1
    chamdan
    chamdan is offline
    Registered User
    Join Date
    07-09-2007
    Posts
    79

    Cool How to show a related Userform depending on the Active Cell value

    Need help,

    I need to show a userform based on the value found in an active cell. Let us say, if the active cell is selected then change the caption name of the userform and change the label content based on the value found in the active cell.

    Regards,

    Chuck
    Last edited by chamdan; 09-02-2010 at 09:28 PM. Reason: Resolved
    Reply With QuoteRegister To Reply
  2. 09-02-2010, 09:18 PM #2
    chamdan
    chamdan is offline
    Registered User
    Join Date
    07-09-2007
    Posts
    79

    Thumbs up Re: How to show a related Userform depending on the Active Cell value

    Solved
    I have found a way of doing it by using the following instructions.

    Select Case UCase(ActiveCell.Value)
    Case UCase("ABC")
    frmUser.Caption = "ABC"
    frmUser.Show
    Case UCase("DEF")
    frmUser.Caption = "DEF"
    frmUser.Show
    End Select

    Regards,

    Chuck
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1