Much is said in the subject.
Using "Private WithEvents frm AS frmMyForm" gives a compile error :
"object is not a source of automation events"
Using "Private WithEvents frm AS Object" gives a compile error :

my excel screen has changed like to (numbers) all rows and colums as
follow :
1 2 3 4 5
2

Quick question for you Excel-Looping-Experts out there…
Today I was working with a relatively simple Do Until…Loop.  I got stuck, so
I turned on the Macro Recorded and got a couple of lines of code from that.  
My code is below…

I need to have the information that I input into one cell (cell A) link to a
different cell (cell B) and stay permanent into (cell B).  Then the
information I put into cell A the next day link to cell C and stay permanent
in cell C.  Cell A is alway a working cell and Cell B, C, ...

I finally replaced my old CRT style monitor whose brightness had gotten
really bad with a 19" flat panel.  I didn't realize until I'd gotten it home
that it is a widescreen one and am not sure if that is good or bad - any
thoughts, given that most of what I create is delivered to ...

I have populated several Textboxes by a listbox selection, ALL duplicate entries have been removed
from the listbox.
The textbox shows data in the same row as the selected Listbox.value.
But as there may be more than 1 matching value to the listbox(not displayed as duplicates are

I'm trying to paste concatenated values to cells on a spreadsheet using
this formula:
ActiveCell.Value = ActiveCell.Offset(0, 5).Value &  " - " &
ActiveCell.Offset(0, 6).Value

(Using Excel 10.1.8 on Mac OSX)
Is there any way yet of changing the text of the tooltip which appears
when the mouse hovers over a datapoint in an Excel Chart?
I know there are solutions using Chart_MouseMove and showing and

I am using the following code to build HLC Stock plots for
discontinuous ranges of data.  There are 4 ranges plotted and 4 ranges
that are the X value labels.  I am successful in referencing each
range and using them to designate the  chart source data.  But when I

I am pulling data into a userform, then if needed it can be modified,
but if i make a modification i do NOT sem to get any data to change accordingly, why ?
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False

Could someone please help amend my macro code so that when it is run,
the SaveAs window pops up and automatically selects the desired
directory location in my macro?
Sub Save_to_Dir()

Would someone be able to provide the code to find a record in an Access
table using data in excel.
ie have an order number in excel and I want to find the record in the Access
database for the order number so I can update the record for that order in

I have an Excel file that works fin when I open, use or close it... BUT....
If I open the file and close the whole Excel application (not only the
file)... then I get Compile error "Method or data member not found"
The debugger focus on the name of combobox that exist..!

Will pay for need help and occasional advise on using excel ....
" sorry if this is off post ...will be my last"
Thx in advance for your help and interest.
 i am an independant oil and gas consultant and have a fair

I am a VBA rookie and am trying to write an Excel Macro which will
clear contents of a cell along with any check boxes and option
buttons.  I got the first part of the macro correct, but when I tried
adding additional checkboxes and options to it, it just don't work.