+ Reply to Thread
Results 1 to 1 of 1

Userform - Want textbox row to clear itself after I move the coursor to another textbox

  1. #1
    Forum Contributor
    Join Date
    02-05-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    184

    Userform - Want textbox row to clear itself after I move the coursor to another textbox

    Hi!

    I'm new and terrible at this , so forgive me if I don't really know how to describe my problem


    I need my user form to clear the previous box I was in when I move the cursor to the next box
    You can only enter data into the extreme left column , and it will fill out the rest of the row with the calculation
    Currently it will look like this when I enter start entering numbers into another row

    A.jpg
    http://i487.photobucket.com/albums/r...ps9da4d823.jpg

    I want it to look like this
    All numbers from the previous row disappear when I move the cursor to another box

    B.jpg
    http://i487.photobucket.com/albums/r...ps270a6f20.jpg


    Also , is it possible to change the default highlight color from light blue to yellow?
    I have circled it in red

    C.jpg
    http://i487.photobucket.com/albums/r...ps9488bcb0.jpg

    Lastly , is there a way to put this directly on worksheet itself?
    Cause I have 3 of these tables and I can't open any other when one of them is opened
    That was I can put one on each sheet and just use the tabs below to switch

    Attached is a copy of the userform
    Gam stage 2.xls


    Thanks for any help!
    Last edited by Nights; 02-05-2013 at 09:48 AM.

+ 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