+ Reply to Thread
Results 1 to 2 of 2

Highlight Row from TextBox in Userform

  1. #1
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Midwest
    MS-Off Ver
    Excel 365
    Posts
    124

    Highlight Row from TextBox in Userform

    In my userform, the user enters a row number into TextBox3. I'm trying to have the entered row highlighted after the user enters it. I think this might be a TextBox3_AfterUpdate, but I'm not sure what code to use to highlight the row.
    Thank you!

    Luke

  2. #2
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Midwest
    MS-Off Ver
    Excel 365
    Posts
    124

    Re: Highlight Row from TextBox in Userform

    I figured it out. It works dynamically under TextBox_Change and also by setting the color index to 0, it will still highlight the row by selecting it, then will leave it with no-fill so you don't have to code it back to no-fill.
    Please Login or Register  to view this content.
    Thank you me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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