+ Reply to Thread
Results 1 to 2 of 2

Select a worksheets based on combobox value

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    Drammen
    MS-Off Ver
    Excel 2010
    Posts
    5

    Select a worksheets based on combobox value

    Hi,

    I want to register data into a particular ark.For example if I have an employee named "Daniel", I want the content to be stored in the sheet named "Daniel".

    Have tryed the following code, but get som error.
    Please Login or Register  to view this content.
    Does anyone have alternative encodings, or changes to get the function to work?
    Last edited by vlady; 10-17-2012 at 03:36 AM. Reason: Use code tags on codes.

  2. #2
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Select a woorksheets based on combobox value

    Hi,

    Remove the double quote.

    ie. Sheets (mysheet).Activate

    Please Login or Register  to view this content.
    regards
    taps

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1