Register
Log In
Unanswered
Home
July 27, 2017
Offline
Hello,
I am having issues creating a questionnaire/form for our staff in Excel. I would like the form to expand automatically when staff enter text as answers to the questions. I do not want staff to have to modify the spreadsheet or format it. I am unable to come up with a solution. I have tried text boxes and merging cells but I am unable to get excel to automatically format the cells or text boxes where text is entered without issues. Text boxes for example can be made to resize automatically with text, but they then overlap the next question or questions on the form. Merged cells have to be manually adjusted if text entered is too lengthy.
Any suggestions to solve this problem would be appreciated. I would prefer to keep the form in excel versus word as it is one tab in a larger file used for estimating job costs.
Regards,
Millhouse2020
Dashboards
June 25, 2016
Offline
Hi
Without a copy of your form it is very difficult for anyone to help.
If you can attach a copy of the form with the issues and your expected solutions, it will help considerably.
You can take a look at the attachment and see if this is what you are looking for (I am only guessing here).
It contains a macro that auto fit rows should there be any changes in a cell.
My assumption is that your questions will be down a single column only.
Hope this helps.
Sunny
July 27, 2017
Offline
Thank you for the reply. Your file is appreciated and may work as an alternative for me. However, I would prefer to have the excel file format itself automatically versus be required to run a macro. The questionnaire is for various staff working on job estimating and I would prefer them not having to modify the file. I can get the text boxes to expand in Word, but not in excel. I could use a separate word file for this piece of the estimating process I would rather include the questionnaire as a tab within the larger estimating excel file.
I have attached a sample file with two tabs. The first uses merged cells and the second uses text boxes. In both cases I seem to be unable to get the answer sections, shaded light blue, to expand automatically as text is entered without overlapping the following questions.
Any suggestions for better alternatives would be very much appreciated. Thanks to all!
Millhouse
Dashboards
June 25, 2016
Offline
Hi Millhouse
Wrapping text in a single cell will cause the cell to auto expand. See example attached.
Sunny
July 27, 2017
Offline
Hi again,
Thank you! This will work fine 🙂 I see my mistake now. I was merging cells and rows and in doing so, that would not allow the area to expand. Using one cell and wrapping the text accomplishes this. Terrific! This was driving me a little nuts. I don't often run into problems will excel I cannot solve. Thank you again.
Millhouse
Most Users Ever Online: 57
Currently Online:
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
