Ive been working for a couple weeks on a program for my business but im new to VBA and have a few hangups. I would be incredibly grateful for any assistance provided.
For the most part everything is functioning the way I need it. The file includes a login feature and several userforms to input data to various sheets, send emails, save forms etc. Where my problem lies is, editing my "Master Roster"once new personel have been submitted (i.e. address changes, new email and phone, etc.)
From my home screen there is a " Add New Tech" button which works great and there is a "search" buttons which is also functioning but what need is an update button in the "search" userform that would allow me to update my txtbox's once the search has returned the results. Ive tried several methods all of which havent worked. It needs to be through the userform because i plan on hiding most of the tabs once the project is complete. And Ive tried the bulit in data form but its not quite dummy proof enough for some of the people using the end file.
Also there are some pretty talented people on here so any suggestions on better code or a more efficent method of doing some of these actions would be more than welcome. Id like this to look and function as professional as possible.
DASHBOARD Demo.xlsm
This is a sterile copy that includes all my code thus far but I had to remove a lot of my sheets to make it fit
username=help
pass=help
Bookmarks