+ Reply to Thread
Results 1 to 3 of 3

user form code

  1. #1
    Registered User
    Join Date
    06-25-2004
    Posts
    21

    user form code

    in this code, my form only works with the one sheet... how do i make it work with whatever sheet I have selected or is active?

    Private Sub cmdADD_Click()
    Dim iRow As Long
    Dim ws As Worksheet
    Set ws = Worksheets("1999 Upper Deck")

    I have several worksheets that require the same info.... card number...quantity..player name.. I have a different sheet for each year and brand in my collection. I really dont want to make a form for each one of these sheets..... how do i change my code to make it input the data into the sheet I have seleced

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    Without seeing the rest of your code, this may work:

    Set ws = ActiveSheet

    Hope this helps,
    theDude

  3. #3
    Registered User
    Join Date
    06-25-2004
    Posts
    21

    the Dude

    the Dude=the Man

    thanks... i was trying to use ActiveWorksheet instead of ActiveSheet......what we call in my line of business a brain fart

    thanks

+ 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