Creating Electronic Form Using Design Mode

[AConneely]

Hi guys,

I am trying to create an electronic form using the design mode but I am running into issues as the file expands.
1. The text boxes seem to move and overlaps other cells depending on that screen magnification I use
2. I cannot control the text size within the textbox when I click inside it when out of design mode for some reason recently the font size keeps getting smaller
3. the more tabs I add the larger the file is getting so it takes too long to upload
Ideally I want a simple form where cells are locked out so the user can only add data to text boxes and checkboxes and can select from the lists

any help would to make this file less clunky would be much appreciated.

Thanks

[protonLeah]

You don't need any text boxes (in my opinion)

[AConneely]

Hi Ben,

This looks great and seems to functions much better...excuse my ignorance on the whole excel field thing but what have you replaced them with and how can I add these type of fields again?

Thanks,

Anne

[protonLeah]

They are worksheet cells, but they are unlocked while the rest of the worksheet cells are locked and the sheet protected so that only the unlocked cells my be selected or changed with data/info.

[AConneely]

Many thanks for your response Ben..for some reason I did not get alerted that you responded until now.