hide cells
 

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.

hide cells
 

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
..

hide cells
 

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

hide cells
 

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