+ 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
    MS-Off Ver
    Excel 2016

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


    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


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


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


    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)


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