VB - interior.color function in Excel

  • Thread starter Thread starter maria
  • Start date Start date
M

maria

Can anyone tell me why
Cells.Interior.ColorIndex = Int(Rnd * 56) + 1
works ok using the forms toolbar with a button click but
does not work if you use the control box toolbar.
 
Maria,

What does "not work" actually mean? What version of Excel are you
using?

Open the Properties window for the control button and change the
"TakeFocusOnClick" property to False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top