View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abby Abby is offline
external usenet poster
 
Posts: 26
Default Textbox - code to drop into a cell

Hi all

This maybe a very simple code and I should know this but I am out of
practise as I haven't used code for over a year and a little out of touch.

I have designed a UserForm with lots of Textboxes and I want to drop each
textbox text into various cells on a spreadsheet (mailshot - addresses and
telephone numbers etc). I want to be able to tab through all texboxes and
when I click on OK at the end it transfers all the text into those cells.

Simple but yet hard for me to get my head round and I'm losing valuable time
- so I thought I would get on here and ask you experts.

Many thanks