Hello Again!!
First off, my thanks again to everyone, and I am sorry if I am becoming a bit of a nuisance with all my questions. This has been a huge project thrown at me, but thankfully I am almost done. I al self taught at all of this, and trying to learn as I go. I do try searching the forum and Google for the answer, and only post my questions when I am stumpted for finding an answer. I truly appreciate all the help I've gotten over the last couple of weeks - many of yo have been absolute lifesavers, solving issues in minutes that I have spent hours trying to hack my way through.
:D
On to my question. The way my tool has been built is that there are 8 tabs - Sheet1 has only a single Command Button that opens up a Form where all the meat and potatoes are, and the remaining 7 tabs have infomation on my clients - names and contact info, inventory and pricing info, etc.
What I am trying to do now is add a Command Button on the user form that will open up the corosponding Clients tab in a new window when clicked. So, something along these lines:
I do already have a variable called Client that captures the name of the Client I am working with.
Thank you again for all the help!!
Bookmarks