PDA

View Full Version : Solved: Textbox to textbox



Glaswegian
02-26-2008, 08:46 AM
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. :banghead:

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

Cheers!

Glaswegian
02-26-2008, 09:05 AM
Ack! Never mind - helps if I actually create the blasted textbox in the first place...........

Norie
02-26-2008, 10:47 AM
Glaswegian

Glad to see you've got the problem solved.:)

But what did you mean here.:dunno

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.