Trying to make it simple
I have a sql table with say 6 entries in
ie
Ben

I need a code example to allow the user to p;ick a color from within the
excel color wheel using VBA.
I have not been able to find one so far.
Thanks

This fragment of code i am creating a lable, but when I attempt to change the
font size in the WITH BLOCK.  Could someone point out what I am doing wrong.
Set control = OLEObjects.Add(ClassType:="Forms.Label.1", Link:=False, _
       DisplayAsIcon:=False, Left:=cw * 3, Top:=rh * ...

What is the correct format of the call statement for a addin workbook that
contains a macro in module1 with ThisWorkbook properties set to addin = true.

I know this topic has already been posted and since I don't know VB
excel programming, I used the code from a previous post to achieve
what i want.
I need to search for blank values in a range and replace them with the

I have a toolbar that runs macros from a locked project of an .xls
file that is always in a standard location. In this .xls file, under
the ThisWorkbook page, one subroutine is:
Private Sub Workbook_Open()

I have a data in Cells G25. And I have 20 xls files in a folder.
What i want to do is I would like to copy the cells G25 from this 20 xls
files into a new workbook. How could I do that?
Please can i have some help?

I'm trying to use the following code snip (adapted from a post by Kieth A.
Lewis) to change a button face, but it doesn't paste the face.  I know the
bitmap is on the clipboard and I can paste the bitmap onto my button manually
through the customize menu, but the call I make to ...

I want to get the result in saskour20per as a percentage.  I wrote the below
procedure which is generating the error "invalid qualifier".
   Saskour20per.Value = (saskour20 / sask20)
   Saskour20per.NumberFormat = "0.00%"

Below is a sample of my worksheet. I'd like to clear the range B1:C3, which
should be the active range minus the Row 1 headers. How can I delete or
clear just the values and not the first row's headers?
LISTING 1:

I wish to obtain a list of all installed fonts wich will feed a ComboBox in
a UserForm.
Thanks for your help
Pierre

I have a list box ListBox1 on a worksheet called Data.  The list box fill
range is List!A1:A12 where I have a list of months.  I have 12 worksheets
with each month for the worksheet name.  When a user selects a month from the
list box I would like to call the corresponding ...

I am using the VB Timer function to feed a countdown timer (displayed in a
cell) and want to be able to edit my Workbook w/o stopping the timer.  I've
tried using DoEvents in a Do loop but as soon as I edit a cell the timer
stops and I have to restart the macro to restart the ...

Where does one store a called macro that would be used by many excel
programs? And how is this procedure done, as well as how is the macro coded
Public or Private?

I have several pieces of code that create pdf files by using save as pdf
(ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:  ...)
This automatically opens the pdf files that are created.  How can I close
these files?