Solved: Textbox to textbox

[Glaswegian]

Hi all

I have a multipage form with various controls and the data is being transferred to a sheet. There are several textboxes on the form and there are matching Control Toolbox textboxes on the worksheet.

For the life of me I cannot get data to transfer from the textbox on the form to the textbox on the sheet!

I know that using Forms Textboxes you have to loop through using Characters.Count but Characters is not a Property of the Control Toolbox textbox.

The fact that Excel has crashed on me already today is not helping my mood.

All I need is a starter for ten - the rest I'll then be able to do myself.

Cheers!

[Glaswegian]

Ack! Never mind - helps if I actually create the blasted textbox in the first place...........

[Norie]

Glaswegian

Glad to see you've got the problem solved.

But what did you mean here.

I know that using Forms Textboxes you have to loop through using Characters.Count but Characters is not a Property of the Control Toolbox textbox.