Insert Function next to formula bar gives Run-time Error '50290'

N

Nick

Greetings,

Background:
We are using Office 2007 Pro Plus on XP SP2. We have a basic XLSM file with
the following Macro code:
Sub auto_open()
Application.OnEntry = "ChangeStatus"
End Sub

Sub ChangeStatus()
Application.StatusBar = "Changing formula" & Now
End Sub

When opening the file, we clicked Options --> Enable macros.

Problem:
When doing an insert function from the ribbon (Formulas tab --> Insert
function button on the far left), select SUM, click OK, enter 1 for number 1,
enter 2 for number 2, enter 3 for number 3, then click OK. The formula will
insert into the cell and the sum of the numbers, 6, will appear in that cell.

Now if you do the same above steps as you did, but this time using the
insert function button next to the formula bar, with the same macros enabled,
entering the same numbers, you will receive a MS VB Run-time Error '50290'.
Clicking Debug brings us to the line, Application.StatusBar = "Changing
formula" & Now, which does not have any issue since it worked with the insert
function button on the ribbon.

Can anyone help with this issue?
 

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

Excel VB Run-time error '50290' 0
Run-time error '1004' 5
Insert row gives run-time error 13 message 1
Best way to insert rows 5
The real Horizontal Formula question 4
Formula in macro gives "Run-time error '1004':" 1
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Problem in adding macro to ribbon through Add-in 7

Top