**Question description:**

*This user has given permission to use the problem statement for this blog.*

I think i have seen this before, iÂ´m trying to find out if you can make excel display a question and make the users answer and the users answer will put in a number in a cell defined by you? For example, how many hours have you been working today, the user replies 8 and that number goes into cell a1 for example.

Solved by I. C. in 14 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/05/2018 - 06:04

Hi Welcome to Gotit

User
23/05/2018 - 06:05

Thank you

Excelchat Expert
23/05/2018 - 06:05

Please explain your requirement

User
23/05/2018 - 06:06

Can you make predifined questions in excel?

Excelchat Expert
23/05/2018 - 06:07

I added a question in A1 cell?

Excelchat Expert
23/05/2018 - 06:07

You mean question like that?

User
23/05/2018 - 06:08

No more lika a popupbox and depending on the answer fill in a predifined cell

Excelchat Expert
23/05/2018 - 06:09

we can add comments over a cell when you hover it will display you comment based on that you have to fill the cell

Excelchat Expert
23/05/2018 - 06:09

like that you need?

User
23/05/2018 - 06:10

for example, you open a worksheet and get the question how many hours have you been working today and the number that the user print i will be inserted in cell a1 for exapmle

User
23/05/2018 - 06:13

We use excel to record our daily work, and everyday we have to fill in working hours and what equipment we have used

Excelchat Expert
23/05/2018 - 06:14

oh

User
23/05/2018 - 06:14

and for how many hours we have used the equipment, so is there a way to predifine questions in excel and make excel itself insert the hours directly into the worlsheet?

Excelchat Expert
23/05/2018 - 06:15

No there is no such this

Excelchat Expert
23/05/2018 - 06:15

We can write VBA but it also requires to open excel

User
23/05/2018 - 06:16

Could you use power query for this?

Excelchat Expert
23/05/2018 - 06:16

My suggestion is to make any web application using ASP.Net and update the entries directly to excel

Excelchat Expert
23/05/2018 - 06:17

This site only supports Excel questions related to Excel formulae

Excelchat Expert
23/05/2018 - 06:17

it won't support power queries, VBA

User
23/05/2018 - 06:17

Ok, thanks and have a nice weekend!

Excelchat Expert
23/05/2018 - 06:18

Nice meeting you

Excelchat Expert
23/05/2018 - 06:18

Have a nice day

Excelchat Expert
23/05/2018 - 06:18

Please end the session

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*