Mac Forum / Applications / Excel / February 2007

How do you get the Watch window to open up when using VBA in Mac Excel
2004? I want to be able to monitor the values of various variables.

Is it possible to look up the value in a cell, and depending on that display
a small graphic from a table elsewhere in the spreadsheet.
At the moment, I have a small "system" which when a user picks a value from
a combo box, it is then put into a cell, then a cell that is located ...

Please clarify how to embed sheet code into Pocket Excel.  Have not found a
way as yet.
Thanks,

Is it possible to look up the value in a cell, and depending on that display
a small graphic from a table elsewhere in the spreadsheet.
At the moment, I have a small "system" which when a user picks a value from
a combo box, it is then put into a cell, then a cell that is located ...

"ZipCodes" defined as name link to other workbook
In a worksheet : '=VLOOKUP("ABX",ZipCodes,2)' works fine!
in VBA : 'x  = Application.WorksheetFunction.Vlookup("ABX","ZipCodes",2)' ->
error

How do I match one data set from one spreadsheet (A) with another
spreadsheet (B) row by row and then delete or highlight on spreadsheet
(A) the data row that matches any row in spreadsheet B, using two
fields as a criteria ('AND' logic) in the search (in spreadsheet B)

This question is for an MVP:  In another thread, an Excel user recommended
Mac Excel Expander.  How might installation and use of its components affect
the stability of Excel 11.3.3?
Respectfully, Norm

On the PC if you place the following code in the Sheet1 object
Private Sub Worksheet_Activate()
   Msgbox "Hello World"
End Sub

Any idea why when I paste a date (format date 03/14/01) into a blank
excel document, the date changes. For example, 09/26/05 becomes
09/27/09 in the new document, although the cell format is the same in
both documents  (format date 03/14/01)?

On the PC if you want to increment through all the Excel files in a folder
you would use something like:
myFile = Dir("C:\Data\*.xls")
Do Until myFile = ""

I have a spreadsheet that reports daily manpower attendance.  One sheet
currently updates other attached sheets to report different requirements
(camp, trade, etc).  Currently we have to manually updated a history page
that shows attendance by date.  I don't know if it's possible ...

Hi, I'm using Office 2004 and have all the updates installed. I'm
having a weird, VERY frustrating problem with either/both my Excel and
Word apps. In an Excel I have 2 simple column charts that are
independent, but side by side in the worksheet. Whenever I select both

My web queries to sites which require a login no longer seem to
work.   In the past, if I was logged on to the site in a browser, then
excel could retrieve data from that site's pages.  Now, the excel
program retrieves the login page of the site, as if I went to the

INPUT OF DATES IS IMPOSSIBLE IN THE EUROPEAN WAY BEING DD-MM-YY
INPUT HAS TO BE MADE IN THE USA WAY BEING MM-DD-YY
DATES SHOWN IN THE FORMULA BAR SHOW AS AS MM-DD-YY
WHEN INPUT IS DONE IN A COLUMN THAT WAS FORMATTED TO SHOW DD-MM-YY IT

How many rown are in the new version of Excel?