VB - interior.color function in Excel

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

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interior.Color from a function yields Error 1004 3
.interior.color hates me 6
Speech Recognition & Dictation in Excel: How to turn it on? 0
Check Boxes In Excel 2
Combo Boxes 1
How do I insert a spinner (spin box) in Excel 2007? 1
Excel 2007 won't open earlier versions 3
Bottom Double Border in Toolbar- Excel 2003 2

Top