Hi Everyone,
Apologies as i am sure the answer to this is in the forum somewhere but i cant seem to type in the right search to find it.
I am setting up a very basic spreadsheet for logging details received from a telephone hotline. e.g. recording people names, location, and some commentry about their call. All in all i have about 30 different fields for each record.
I want to use a userform to enter the data as this is more userfriendly than scrolling though the columns.
Is there anyway i can amend the standard userform that is generated by going to "Data" and the "form"?
Basically i am being lazy and want to save time by not haveing to set out all the text boxes on a blank form and code it up. But on the other hand i want to format it because the standard form looks poor.
any help would be much appreciated
thank you
Apologies as i am sure the answer to this is in the forum somewhere but i cant seem to type in the right search to find it.
I am setting up a very basic spreadsheet for logging details received from a telephone hotline. e.g. recording people names, location, and some commentry about their call. All in all i have about 30 different fields for each record.
I want to use a userform to enter the data as this is more userfriendly than scrolling though the columns.
Is there anyway i can amend the standard userform that is generated by going to "Data" and the "form"?
Basically i am being lazy and want to save time by not haveing to set out all the text boxes on a blank form and code it up. But on the other hand i want to format it because the standard form looks poor.
any help would be much appreciated
thank you
