I have two comboxes in my worksheet. The first has 3 selections and each
selection changes the data in the second combobox, which has 7 selections.
Each of the 7 selections will change text within cells. I have the second
combobox setup to change by selecting a case of the first one ...

I am trying to get the values out of 'buffprice' and 'buffdate' .  When
I copy them to a range I only get the first value of each duplicated
down the entire range.  How do I get each individual value?
thx

in very simple Excel Com Add-in, I want to change the font of the given
range by using Font->set_Bold(true). Unfortunately, I do not ga that
far. It throws when I do get_Font().
Object* ExcelAddinModule1::frumk(Object *rg)

Hi again,
I already asked about this, however I still do not know where to put
the lastrow (sorry but I am not very familiar with this programming
language). I already did a macro with a certain number of rows.

Hi...
I've populated a combo box with say sheet 1, sheet 2, sheet 3, and sheet 4.
What code will take the user to sheet 2, if sheet 2 is selected from the drop
donw combo box. Are there amny examples of this around...

I want to delete groups of 9 continuous rows from where a flag: "X" is found
in col K. Eg: if K10 contains: "X", delete entire rows 10-18, and if K100
contains: "X", delete entire rows 100-108, and so on. Thanks.
--

I have a simple code to save a couple of pages of paperwork to a file to be
emailed to corporate nightly, It works fine.  The problem that I am having is
that if someone runs this script and chooses to cancel the process at any
point I get a run time error 1004:  Method 'SaveAs' ...

In the code below I created a dynamic range, the range name is based on
the contents in cell 2 of a column (in this case text) and the sheet
name. How can I then place a formula into the 1st cell of the column
that totals up the contents of the dynamic range, using the dynmaic

Hi...
Looking for code that will remove column headings and row numbers from
within the auto open routine. I can do it for a selected sheet but not for
workbook.

Hi, Im using a userform with list boxes. In vna Im using
ListBox1.AddItem to add text. When I ad text the list boxes show scroll
bars, is there a way to stop these as I dont need them and they make
the form look untidy.

I have a rather large workbook. I would like to have a link to each tab on
the first tab (worksheet) in the workbook. What I envision is a cloumn of
cells with the sheet names in cells. When the cell or text is clicked on, the
user is taken to the corresponding worksheet.

I have a spreadsheet in which a value is automatically imported into B2
each day.
I would like B3 to automatically show the maximum value ever reached in
B2 and, in B4, the minimum ever reached by B2. Could someone advise me

Ok let me give you all an example:
C    B
4673923    1987
4717817    1991

Help with creationg a MsgBox with VBYes and VBNo, then putting a 1 or 0 in
Sheet4, cell C4. Probably putting the code in Workbook Open?
Example:If date is =>July1 and <July 5 then Msgbox "Do you qualify for Bank
Day? If VBYes is selected then a 1 is sent to Sheet4 cell C4, If ...

is there any funcion like between() (such function is available in visual
foxpro