Hello, I am using Excel 2010.

I don’t work much with spreadsheets, and I’ve never created a form for a spreadsheet. I would like to try making one, but is it possible to do without VBA code?

I’m concerned about something, though. I want to be sure the data I enter will appear in the spreadsheet exactly as I entered it. Please allow me to elaborate.

First, I want a check box. If I click on the check box, I want the term “Full-Time” to be entered into the appropriate cell for that record. The check box should be unchecked by default. Nothing should be in the cell if it is unchecked.

Is that possible with an Excel form? Can it enter the text, and not a numeric value representing the text?

Since I am unfamiliar with Excel forms, I must also ask this question: Once I add the data to the spreadsheet via this form, can I review the data via the form? If so, will the check box appear checked for the records that I used it for?

Second example: An option group with radio buttons. I want five radio buttons, each representing different text. There will be a default button, and I do, in this case, want that default text entered into the cell.

If I select a different radio button, then of course, I want that text entered into the cell. I’m trying to avoid numeric values. Is this possible?

And, of course, if I can review the records in the spreadsheet via the form, will the appropriate radio button be clicked when I go back to review the data? (Assuming review via form is possible.)

Can creating a form with these elements be done without code, or VBA, or macros?



Thank you! Jd