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.

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.


---
Regards,
Norman
..

On Jun 5, 4:12 pm, prog wrote:
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

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.

"gmunro" wrote:

On Jun 5, 4:12 pm, prog wrote:
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