I have a workbook with a UserForm that is accessed by five different
computers. On some the UserForm fills the screen and on others it
fills about a third of the screen.
Is there anyway to get vba to check what machine is opening the
UserForm and adjust the form accordingly?
Re: Powerpoint with VBA help ... invoking any property or method of a form causes the form to load.... > The userform and macros work fine on only two computers. ... > these are the two computers where the two coders sit. ... > On Error GoTo Errorhandler... (microsoft.public.powerpoint)
Powerpoint with VBA help ... The userform and macros work fine on only two computers....Powerpoint 2002 with SP3 and the other with Powerpoint 2003. ... (microsoft.public.powerpoint)
Re: Excel is forced to close when run a marco??? ... You basically export the userform... import the exported userform back to the workbook.... This opens my userform OK, ... hold the shift key while you open the 2nd workbook so excel opens in safe ... (microsoft.public.excel.programming)
Re: Update Personal Workbook Macros when Workbook is opened. ... There would be a single delay to open the addin, but loading the data file would ... dim testwkbk as workbook...set testwkbk = workbooks ...userform for the sales team to enter specifications of the ... (microsoft.public.excel.programming)
RE: HELP: Populate form fields (intranet) from a workbook(network ... Now they want me to put the data into access database and make the userform... Your data is stored in a workbook on network shared drive and you just need ...Dim MyPassword As String ...Set SourceWB = Workbooks.Open(DBFile, ReadOnly:=True, ... (microsoft.public.excel.programming)
