A very newbie to VBA

[irresistible007]

Lets say I have put a Text box on top of my sheet (picked from Activex Control Toolbar). Now i want the cell G10 to show the contents whatever is typed into it - what will be the code?...

Also, can somebody recommend me a site from where i can learn how the above type of coding is done cuz i am upto a project where a lot of such simple coding is required

 

[jdavis9]

right click on the text box select Properties, then in the list of properties selet LinkedCell and type G10. Now turn off Design Mode, and type in the text box, what ever you type will appear in G10

 

[irresistible007]

hmm... thats was fairly simple ... is there is any website which you or anyone else like to recommend from where i can learn such coding...

Like what if i want to use that textbox to send the contents to G1 when a command button beneath it is pressed and same time clearing itself so as it can be re-used to send contents to next blank cell in that column

 

[jdavis9]

When you have a question, this is a great place. If you want reference material. Try the following books:

MicroSoft Excel "your Version" Power Programming with VBA
MicroSoft Excel "your Version" Bible