Inputting data from text boxes into different worksheets of a workbook.
Posted by M Walker on July 17, 2001 1:31 AM
I'm having a little trouble with the macro that i'm writing. I would lik the user of my macro to input data into a textbox and upon exiting put the data into the spreadsheet into a specific cell.
At the moment the user can select an item from a drop down box but can i use the selection to reference a cell (and if i can i haven't got a clue what the code is!)
Just to round things off nicley i would like the new total to replace the old one - save upon exiting excel.
ANy help would be very much appreciated.
Thanks in advance,