hide cells

[Guest]

Hi,

I'm looking for some help in VBA to hide certain cells on form load. It has
been awhile since I did any vba programming, but is the form load function
Form_Load() ? Also, how do I choose individual cells to dim or hide, without
hiding the entire column or row? Thanks.

 

[Norman Jones]

Hi Prog,

'------------------
I'm looking for some help in VBA to hide certain cells on form load. It has
been awhile since I did any vba programming, but is the form load function
Form_Load() ?
'------------------

Try:

'=============>>
Public Sub Tester()
UserForm1.Show
End Sub
'<<=============

'------------------
Also, how do I choose individual cells to dim or hide, without
hiding the entire column or row? Thanks.
'------------------

Perhaps, try setting the cell's font and inrerior colours
to match.

 

[gmunro]

Hi,

I'm looking for some help in VBA to hide certain cells on form load. It has
been awhile since I did any vba programming, but is the form load function
Form_Load() ? Also, how do I choose individual cells to dim or hide, without
hiding the entire column or row? Thanks.

You could also try conditional formatting so that data is in white
font (assuming a white background) based on the value
Would that work?

Glen

 

[Guest]

I'll try that. Also, just to let you know I'm inserting the buttons right in
the Excel spreadsheet, for this project. I'm not using a vb form or anything
like that.