This is my first attempt at VB for excel. All I’m trying to do is write to a
cell using a form with a textbox and a command button.
I would think you would do it something like this but it’s not working.
Private Sub CommandButton1_Click()

I am using the macro below to make a new sheet from a template, and then
rename said sheet(s) from a "selected" list (read highlighted). This worked
great, until I decided that I wanted the selected cells to have data from a
reference. Now the macro only makes a duplicate of my ...

Here's a new one...
I have an accounting workbook with some hidden sheets based on months.
All month sheets have a Fixed heading with some accounting information
below it and further down the sheet, a Unpaid From Last Month heading

I have a text box on a form. When the user selects the text box it is
*always* to completely change the value. Therefore I would like to
program an event that selects all the current text in the text box
when the user selects it - that way they are ready immediately to

I have an excel spreadsheet which is used on different versions ie 97 & 2000.
I need to be able to email the spreadsheet using a macro however at the
moment I get a compile error.
We are unable to set the library reference on the 97 version because to save

I am trying to activate the previous sheet in my code.  My macro does
some code from the current sheet but then needs to pull some
information from the previous sheet.  I get an error when I insert the
line

get file not found have changed file name numerous times to no avail.
reloaded office 2000 code is good does anyone have an idea as to why it wont
find file.
this is code I am useing files are in folder opens yearly fine copied code

if i declare array in a standard module
are they be manipulated through subs?

i have several arrays defined with dim statement
e.g. dim a(),dim b(),dimc() and so on
is it posssble to redim these arrays using for...each statement?
thanks

I am getting a headache from trying to figure this out.  Any help
would be greatly appreciated!
I posted this earlier...
Okay, here's a new one for everyone...

I want to set the column widths to various sizes.  I have columns A thru P
with headers and I want to make a macro that sets the column width of each
column to a certain size.  For example column A 5.29 or 42 pixels, column B
16.00 or 117 pixels, etc.

Can one copy an Excel workbook in a local directory to another directory
on a server (assuming no password is required) using a macro within an
unrelated Excel workbook without the file to be copied?  This is what I
tried that did not work:

Please help me on my problem, I am new to macro definition so don't be
surprised if I don't know some essentials. Well, I took some online
tutorials, and tried to learn macros myself, but it is more difficult
job that I thought it will be. Any advices are welcome.

i have inserted a ComboBox called "ComboBox1" into an Excel Sheet. Now
I would like to fill this using vba.
unfortunately ComboBox1.additem "test" does not work. this only seems
to work when i insert a combobox into a user form.

Hi, I have a worksheet which was given to me which already has a Combobox
attached to a cell within the worksheet and when a selection is made from
the drop-down box  a value can be chosen from a lookup range of cells
located lower in the worksheet.