Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: text box as output

    ok everyone sorry I have another problem so soon but I have been wrestling with this one all day.

    used find macro
    found cell
    made active
    need the into in active cell to appear in textbox1 on a userform1 that appears automatically when the find macro finds the value

    the book i am using says I can use properties but i think he is using a different version because he has different properties I am using Excell 2000

    any help?

  2. #2
    Join Date
    Jul 2004
    Posts
    34

    got it

    nevermind everyone I figured it out.

  3. #3
    Join Date
    Mar 2004
    Location
    Minnesota, USA, Earth
    Posts
    65

    What was your solution?

    What was your solution?

  4. #4
    Join Date
    Jul 2004
    Posts
    34

    My first answer :)

    set what you want to be in the text box as active then use

    textbox1 = range(Activecell.column & Activecell.row)

Posting Permissions

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