Forum Discussion
creating a form
is there a way to have a form built using code? We have a list of client that I would like to create a dashboard or home form to where you could search the name from a list and pop up the information about that client. Is this possible?
3 Replies
Hello,
yes, that is possible. You can use VBA to build forms in Excel. There will be a learning curve!
is there a tutorial somewhere to help me figure it out? Or is there a source to where I could pay someone to write it for me?
There are lots of learning resources about VBA on the web. You will need to do some digging and experimenting and be open for things. You won't find the perfect tutorial that shows you exactly the steps you need to solve YOUR specific problem.
If you search you can find tutorials about VBA forms and how to use them to read and write data from/to an Excel sheet.
The idea here is that you need to do some research and be ready to learn and try out a few new things yourself. It can be quite rewarding.
