Enabling Excel user form to scroll to previous records + hiding application

I am working on an Excel user form, and have created a form that enters data into a sheet called 'TrackingSheet'. I would like to make the following enhancements:
  1. Have only the user form visible, and not the Excel application.
  2. Enable the user to scroll back to previous records within the user form (read-only view)

I have attached the user form I have created.

Thanks,
Andrea
ProdMainTimeTracker_EE.xlsm
AndreamaryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsExcel & VBA ExpertCommented:
Hi Andrea,

Try attached...

Before clicking Previous or Next Button, select any item from List Box. Will this work for you?
Andrea_Mary_ProdMainTimeTracker_EE.xlsm
Neil FlemingConsultant and developerCommented:
@Shums: One suggestion - your code hides the Excel application permanently. When I re-opened it, the application crashed.

You may need to add to your "cancel" button something like

Private Sub cmdCancel_Click()
    Unload Me
    ThisWorkbook.Close SaveChanges:=True
   'RESTORE EXCEL VISIBILITY>>>
    Application.Visible = True
End Sub

Open in new window

ShumsExcel & VBA ExpertCommented:
@ Neil,

It doesn't crash here :) I tried many times before uploading final version. I haven't used Application.Visible = True or hiding Excel Application completely as probably Andrea doesn't wanted user to know if its Excel.

I just noticed date format was not displaying properly :)
Andrea_Mary_ProdMainTimeTracker_EE.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

AndreamaryAuthor Commented:
Very cool, Shums, thanks so much for this!!
Cheers,
Andrea
BTW, if I want to view the VBA for the form, how do I access it?
ShumsExcel & VBA ExpertCommented:
Andrea,

Once you open this file, open another excelfile. You will be able to see developer tab even userform is on top view.
Neil FlemingConsultant and developerCommented:
:) ah OK. Maybe I had put Excel into an unstable state some other way... quite likely ...
AndreamaryAuthor Commented:
Thanks, Shums, for letting me know how to access the developer tab...

Cheers,
Andrea
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.