Results 1 to 5 of 5

common userform for sheet 1 and sheet 2 but need data to populate from a different row

Threaded View

dav2020 common userform for sheet 1... 12-20-2019, 05:05 PM
mjr veverka Re: common userform for sheet... 12-20-2019, 06:44 PM
dav2020 Re: common userform for sheet... 12-20-2019, 07:55 PM
jeffreybrown Re: common userform for sheet... 12-20-2019, 08:20 PM
dav2020 Re: common userform for sheet... 12-20-2019, 08:33 PM
  1. #1
    Registered User
    Join Date
    12-19-2019
    Location
    mi, usa
    MS-Off Ver
    2013
    Posts
    12

    common userform for sheet 1 and sheet 2 but need data to populate from a different row

    am using double click on each worksheet to open form

    If Not Application.Intersect(Target, Range("b2:b" & lastRow)) Is Nothing Then ' OPEN FORM ON RECORD
            Cancel = True
            UserForm1.Show
            Cancel = True
            End If
    I tried with code on the form to tell which sheet was clicked so i can know which row to get the data from to populate the form
    I tried to check the text from a cell on the activesheet but that doesn't work

    If ActiveSheet.Range("A1").value = "Date" Then getrowa = ActiveCell.Row
    If ActiveSheet.Range("A1").value = "Event Date" Then getrowa = Worksheets("schedule").Cells(ActiveCell.Row, 10).value
    what is the right way to do this?
    Last edited by jeffreybrown; 12-20-2019 at 08:19 PM. Reason: Please use code tags!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Common fields data update sheet 2 to sheet 1
    By girish kanth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2016, 01:02 PM
  2. [SOLVED] Find order and populate userform with the data from a sheet
    By intex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2016, 04:36 PM
  3. Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data
    By roxybethany in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2014, 12:08 PM
  4. Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data
    By roxybethany in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2014, 02:05 PM
  5. Replies: 1
    Last Post: 07-25-2013, 05:09 PM
  6. Populate Excel Userform with Sheet names with double click to open the sheet ??
    By Shacker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2013, 03:54 PM
  7. [SOLVED] Excel VBA: Dropdown box selection in first sheet to populate 2nd sheet from 3rd sheet data
    By EMLalan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2012, 09:46 AM

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