Search results for query: *

Yep, that did the trick brilliantly! Thank you very much, Patron

Golly, its as simple as that? Yikes. Thought it would be far more around the houses. Thank you very much skip, will give it a try. Thank you! Patron

It is a series of userforms which start off at a login before going onto some others for performing loads of calculations. Currently to get to the first sreen the user needs to open excel, open the file, to the editor, find the login screen and then press the run button. A bit long in the...

Hi Skip, Thanks for the quick reply. They are a series of Userforms through which the user inputs data which is then calculated in the worksheet and the calculations displayed back through the objects. Any idea how I could go about getting it to create an executable?

Hello all, Am quite new to VBA although have briefly (very) used VB.Net. Have created a series of forms using formula within Excel and am now just about finished. This may seem a simple question but I really don't know what I do next. How do I go about transforming these connected...

Thank you, Will give it go and take post suggestion for future reference. Wow, so many forums, so little time.

Or any idea how to turn it into an installable application? I know that .net has a wizard feature or something of the sort but am unaware of how to go about that sort of thing in VBA.

Hi Remou, Sorry, um basically I've created an application and would like to get it running without the workbook/ sheet being in the background. The ideal would be to go from a desktop shortcut which opens the application straight to one of the forms. More stand-alone really as a...

Hello all at tek-tips, This may be a basic question but please bare with me. Can a user access a VBA application straight from the desktop without first opening the workbook? I have created an application in VBA using excel data and wondered if the worksheet in the background was really...

Do you know if there is a way to get it to do a multipage print? Thank you both for your help! PATRON

Its a UserForm based on an Excel application PATRON

Hi there, It cuts off at the bottom. I get about 70% of the form printed. Vertically the form does not fit on one printed page. Horizontally it fits fine. PATRON

Hello all on tek tips! Having a slight problem. I've got a rather long page to say the least and about 30% is not being printed and it does not continue onto another sheet as I thought it would. Is there a way to get it to print the whole form? Any advice would be very much...

Hello all, Sorry but two questions: Is there a way of playing a short avi sequence within a form or running an avi sequence (like an introductional movie) prior to a form loading up? For example, say you login then see an intro sequence before the main menu pops up? Have tried a few...

Hello PHV and mintjulep, Thank you both very much, that did the trick brilliantly. Got the integer part but not to tell it to temporarily store the count value so it could work on it in the future. Never mind, almost there but not quite. Will keep in mind the unload aspect as well! That...

Hello all, Am having a little trouble. I am not particuarly technically minded and so I am looking for a little help as despite trying a number of things, nothing seems to help. I am trying to use a counter in a password access form so that after a certain quantity of tries, the...