Front end interface

[Niven]

Hi,

I have been working with VBA for about a year now and more recently Access. I am quite fascinated with creating userforms and allowing users to enter data and e-mail and so on. What I want to find out is how would it work if I wanted a user to click a button (maybe an application, I don't know) on their screen and it opens the userform only, instead of opening the actual program like excel and access where the userform has been created?

I think it probably involves programming in other languages, but I am not sure.

Any help please!