VBA anyone?

[Matt_B]

10 Print Hello
20 Goto 10

 

[Darth Vodka]

10 Print Hello
20 Goto 10

10 print "hello"

 

[Matt_B]

thats why it never worked!

 

[Durham Fox]

Does no one use Cobol these days?

yes they do

 

[Darth Vodka]

back to VBA...

anyone know how to make the msgbox NOT appear in the middle of the screen?

 

[Macky]

back to VBA...

anyone know how to make the msgbox NOT appear in the middle of the screen?

Yeah, don't use the msgbox function & it won't appear.

 

[Darth Vodka]

Yeah, don't use the msgbox function & it won't appear.

no need to be facetious mr macky

 

[Macky]

no need to be facetious mr macky

No reason not to be facetious either :icon_wink

back to VBA...

anyone know how to make the msgbox NOT appear in the middle of the screen?

There's an MSKB article on it here that may be of some use and another page here that is more geared towards VBA.

 

[Darth Vodka]

jeez

cheers macky, i actaully found a work around (i moved the things behind it) my next work around was gonna be to to use a bespoke form, but cheers for that, i may write that into a subprocedure for future use

give the man my vcash

 

[Darth Vodka]

ok next VBA question

i have a procedure in Access VBA that formats an Excel worksheet object that is being created by another procedure. works fine but am having problems switching the gridlines off (the property is DisplayGridlines, but it's on the Window object)

Sub FormatWorkSheet(oWorkSheet As Excel.Worksheet) 
With oWorkSheet 
.PageSetup.Orientation = xlLandscape 
End With 
End Sub

i'd expect something like

oWorkSheet.Parent.DisplayGidlines=false

to work, but no

any ideas anyone?

 

[Darth Vodka]

got it!