Excel Problem?

Question

I would like to ask if how can I put a click button in my excel worksheet that when I press It it will show a list of choices, and when i click on it will be the entry in that cell. Or just teach how to make a click button in excel, another thing is, can I locked the scroll bar in my worksheet so that it will not go further, let say until coloumn G then until row 20, is that possible? Freezing is far different from locking the scroll bar right, please help me...

Answer 1

Indeed welcome to A/S ICT:

Here what you do:

↓ Excel
↓ View
↓ Toolbars
↓ Select the "FORMS" toolbar
↓ A small box will appear
↓ Scroll the options for "BUTTON" on the right
↓ Drag the size of the button
↓ Re name the button

↓ Now you need to create a Macro
↓ Seeming as I can not see your system I can show you what to do but now the exact method.

↓ Excel
↓ Tools
↓ Macro
↓ Record new Macro
↓ Give the marco a name
↓ Now click as normal to perform the function you want - even show more pages etc...
↓ Stop recording

↓ Now right-hand click the button
↓ Click assign Marco
↓ Choice the marco you created

Complete
This is so hard to explain but I hope this helped.

Answer 2

Open Form Tool bar from View->Toolbas option, then select push button option and draw a push button in ur sheet and then record a macro. Then when u will press the button it will do that series of work u recorded.

Answer 3

To add a click button you have to go to toolbars and select the Forms toolbar. Then you just click on the button option and draw the button and link it to the macro to do whatever you want it to do.
Hope it helps.