Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Arrow Unanswered: pick userform by searched column location

    I have two sets of data on one spreadsheet side by side. I searched for a value and found it but now I need to load one of two userforms depending on what column it is in. I was originally going for an if else statment saying:

    if xlcolumn(A)<value<xlcolumn(J) then
    load userform1
    load userform2

    if that doesnt work would a case statment work

  2. #2
    Join Date
    Feb 2006
    Just catching up on some old posts and found this one unanswered. Is it OK now?

    If not, please post again. Sounds like a VBA Find(xxx).Column would do the job. Find returns a range (or nothing if not found) and the .Column lets you know the column. EZ?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts