Can't change NumberFormat via Command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a piece of code as follows :

Dim myCell as Range
For Each myCell in Selection
MyCell.NumberFormat = "@"
Next myCell

When I select a range of cells manually and run the macro from the <Tools>
menu in Excel '97, it works fine but the problem is that if I put this code
in a button_click Sub, I get the error message 'Unable to change the
NumberFormat property of the Range Object' for the code 'myCell.NumberFormat
= "@".

Could someone suggest a reason(s) as to why this happens, I am completely
dumbfounded.
 
Rightclick on the commandbutton
choose properties
Change the .takefocusonclick property to false

This bug was fixed in xl2k.

ps.
why not get all the cells at once and drop the loop:
Selection.numberformat = "@"
 
Cheers Dave, I'll give that a go later and if it works I'll be a happy man.

I have tried theSelection.NumberFormat method you suggested as well but the
same thing was happening.

Thanks again.
 
Change that .takefocusonclick property--no matter which version you use.
 
You must log in or register to reply here.

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

How to add condition to coding? 1
Help with changing code 3
Code to delete names works in one WB, but not another WB? 2
Desire ChangeEvent not triggered if ChangeEvent was column (field) insertion 9
auto running macro 2
Why is Cell not an object 1
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0

Back
Top