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!
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!