I have 2 combboxes in a user form,
txtprice = 5
txtqty = 2
And i want in the third combobox to display the result of the multiplication

I've used a macro written by Tushar Mehta to delink charts in my
worksheet.
I need to delink all worksheets and have tried adding some code to
activate the charts one at a time.  It seemed to work fine one time,

The following express gave the condition of 100% when $ was missing, and when
added it gave a 0%, any reasons why?
=IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF(OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="LP",$F5="RVP",$F5="UA") ...

I was asked to write a database input device in Excel.  I had all my
code and my Userform functioning on a PC.  I was also asked to make
this program available for a Mac as well.  I put the code and the
Userform into the Mac (of course I had to redo the Userform because

Hi;
I tried variuos codes, with no luck. Don't mind the extra variables.
it's left over from previous code which I have been trying.
Here is what I am trying to do:

i'm populate data to an excel file and i active protaction sheet
one of the problem that i cannot figure out is how can i make the
comments appear during the protection as well

I need to implement a user form that let's the user pick one of five
cases (basic, increased, decreased, superior, inferior) and when each
is picked, it runs a macro that changes specific cells.  I have all
the macros recorded and saved, I am just clueless as to how to get the

sI have a Find macro button on a large spreadsheet.  When I use it to find a
word sometime it is difficult to spot the active cell.  Is there anyway to
temporarily (I mean just while I am in the cell) shade the cell so it can be
easily recognized.  At present, of course, it is ...

Hi, I have a simple conditional format, where cell a1 goes red, if it
is less than a value in cell b1. If it is greater than or equal to it
is green.  The problem is I have 300 rows to do this on.  I obviously
dont want to go down all the rows putting the details in each time. If

A couple of weeks ago I send an email asking for code to automatically set an
appointment in my calendar depending on the date in a certain cell. I want to
be reminded when a certain date arrives and I need to take an action. Bernie
was kind enough to send me the following code.

I have sheets full of data all in one column.  There is no way to get
the info out of our system other than to copy whats on screen.  In
doing this it dumps it all into column A.  It does enter into multiple
rows which is but I need to extract data from the cells.

(apologies - I tabbed in my code and managed to send previous email
before finishing)
I have written an AddIn (call it AddIn_2) which picks up where another
(AddIn_1) leaves off.

Hey all,
I have a drop down list which contains names of 3,200+ companies. I
used the menu option Data, Validation, and Allow List and point to
cell AP2:AP3225 for the company list. Now, is there any way for me to

I have an application that prompts the user to select a text file for
processing which is done by using the 'GetOpenFilename' from the
Microsoft Excel object library.  I'm not using Excel in the program
so

I currently have a VBA code which opens up pop up calendar for users
to select a date.  The problem I'm having is that any user's machine
which doesn't have Calendar Control 11.0 installed receives an error
upon opening of the workbook.