Harald,
I have successfully completed my task. i carried out the following:
1. moved away from the cmdadd1 routine
2. Looked at the initial button being pressed
3. Added the TxtId.Text = Range("Contacts!A1")
4. Then entered userform show
5. Changed values inside form to coincide with instruction

it now works just as i want it to. I am not very good at this as i have only
been doing this for about 2 months. I am from a deisel programming background
in autocad. I am not sure where your remarks were leading in regard to
"You didn't tell, so it's sort of a convention to say it's in A1 and then you
replace A1 with the real address;
- WHEN is this going to happen?" but i'm sure it is in good faith :) i have
been struggling with this type of work that i have been i suppose, pushed
into by employment requirements!! Ibthank you very much for all of your help
in his matter and i'm sure, will be in contact again.

Kindest Regards,

Nigel


"Harald Staff" wrote:

Hi Nigel

Ok, read the file. Now consider
- Is "A1" really the cell where your formula is ? (No, it's in E2 ... ) You
didn't tell, so it's sort of a convention to say it's in A1 and then you
replace A1 with the real address;
- WHEN is this going to happen ? You are putting this in the Click code of
the form's cmdAdd1 button. But that's a little late ?

Apologies for not just posting a paste&go4free solution. I want you to think
this through ;-)

HTH. Best wishes Harald


"Harald Staff" skrev i melding
...
Ok. hstf at hotmail dot com

Harald

"Nigel" skrev i melding
...
Hi,

Can i email the workbook for you to look at? nothing seems to show in
the
desired textbox.