Microsoft Excel Programming

UserForm Help
Declarations Procedure and Duplicate Declarations
Auto Deletion of certain Rows in a spreadsheet
How can I protect only cells that meet certain conditions?
Looping
Passing User Defined Type Array to Listbox
Combining specific ranges from multiple worksheets into one
time to calculate (one cycle)
Sheet Lookup
stop a macro if it does not contain
Excel - MS Query - changing location of Access data source
referencing hidden sheets
Is there an object similar to Matlab vectors/matricies/cells?
Menu Item Action Changes with "User" accessing file
new line character in cell
Double click in cell using VBA
Multiple lines desired in Msgbox
Starting telnet/ssh from Excel
Need a psswd verification form to open when the file is opened
Formatting text differently within a Msgbox
looping question
Else If Problem
Send Email VBA
Re: Send Email VBA
Object Required
Open workbook with scheduled tasks?
Re: Convert Number to Words (Indian Format)
Does excel worksheet have unique ID?
Re: Call a add_in function in excel vba?
Startup settings for specific workbook
AutoOpen in excel?
Viewing posts
Invalid Next Control Variable Reference
Opening Excel & Addin
I need to control how users sort in a specific excell worksheet
Array and resize
I need to control how users sort in a specific excell worksheet
Crazy Formula or Macro
After dismissing getsaveasfilename dialog, my userform becomes inactive
add a new row
Keep leading zeros in a string array
Re: How to change Button Caption?
Find wildcard text within a cell
New Workbook through VBA
Set Location and Filename to replace GetOpenFilename
Re: Call a add_in function in excel vba?
GET.CELL(4, What is TYPE?
Setting a Range name
Help for a combo box
Load a range of cells into a dataset with an opened workbook instance.
Object Required
Is it possible to choose a macro based upon a valve of a variable??
Unstable Code
Excel.xmlMap not defined
xl Dialog Function Wizard Arguments
Re: Macro to copy contents in current row to Sheet2
Cont question
re: add new row
automatically create a spinner and link it when a button is pressed
Automatic Saving as Web Page
Runtime Error
Re: listing the names of files
How to customize error bars by VB code?
create a print menu
Buttons move when printing
Isnot there anyone who knows this?
Autofill the formulas and supress the messages
How to look at objects in the form
VB Script
Macro with =SUM doesn't work
How to open file in the background. It is possible?
Validate data in userform data entry
Define name automatically
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
Too Many/No lInes are copied over
match / lookup
RE: Auto Deletion of 4 consecutive rows out of every 5
RE: Can you linke a ComboBox in a Form
Smoothing a chart line using VBA
Auto Deletion of 4 consecutive rows out of every 5
excel 2000 vs excel 2003: locking drop down boxes?
Run time error
Distributing an add in
Creating a help file
searching excel with a form and returning the results
VBA Code to Select Range
Autocomplete question
Suggested answers didn't work
RE: How to desactivate the mouse scroll
Random glitch?
Value From xlDialog
Can you linke a ComboBox in a Form
Need help to auto delete 4 of every 5 rows
Opening multiple workbooks
Web Query -- Timeout Issue
Autofill linked
RE: Excel Edit Form
Auto Deletion of certain Rows in a spreadsheet
Program compatability - 2002 vs. 2000
RE: Deleting rows with no value in column A
Excel Edit Form
Deleting rows with no value in column A
How to desactivate the mouse scroll
Last Column Macro
Excel DataForm not picking up correct list
Getting random cells entering date please help
Excel DataForm not shwoing right data
Foto Slide Show...
Re-define a range in cells
Deleting blank values from an array
Copying and pasting cell contents
Regression
Selection_Activate
Re: Average based on value, not cell location
Do..Loop
What is going on?
How do I code VBA to return information from a web site to an excel workbook
How to run EXE program from button?
Combobox that would select worksheets
Capitalize input
OLEObject data retrival problem
Copy & Paste Unique Cells Values
Msgbox display for defined time
EXCEL, VSTO: Fastest way to access multiple cells
event sub not active
Psswd protect a sheet automatically upon closing file
Excel 2003 Workbook Issue
Execution process of Web Query
referenced component 'excel' cannot be found
Problem with Excel-VBA - Open Command after SP3
Drop down box Help
load speed
What is the limit of the line continuation in VB
Hyperlinks and worksheet protection
Sub to list colorindexes and the corresponding fill colours
how do I use COUNTIF in excel. using criteria from multiple colums
Next without For
Select Activecell in Range
Strange Excel behaviour in debug mode
Locked in
POwerpoint information
Tool bars and menus
Flashing Cells (Like stock quotes)
Combo Box
Last Cell
Example of box with more than OK and cancel options?
solver in macro
=now() -30 days
Dropping blank pages from Excel Spreadsheet's Printout
Folder Size
macro select next blank cell in a row
automatically fill in a cell if the adjacent cell has any value
Selection.worksheets
Using COUNTIF with two different criteria
End With Without With
consecutive numbers
Re: consecutive numbers
problem: changing a text frame's contents from an outside applicat
How to retrieve autofilter column values
fancy forms
Deleting all worksheets in a workbook except two
Re: Isolating New Entries
Solver VB interface 'SolverOK' fails
Relative Cell Reference Resolution Issue
Counting Rows Then Counting Values in Columns
MINIMUM OF POSITIVE VALUES only
adding into combo box and removing duplicates
Delete a Commandbutton from another Workbook
XValues with variable end row
HELP on TRANSPOSE related function.
Extract Key word
Auto button numbering
where's my XML?
Re: HELP on TRANSPOSE related function.
Adding Cells from Multiple Sheets
Subtotals
Summary report questions
[HELP] How to use command buttons in cycles
Workbook slows down all macros
Checkbox toggle true/false
On error resume next? question - problem
Referencing Workbook Name
Clear contents/keep formula
how make a selection like sum function's
can you show formulas in selected cells only of a worksheet?
How to use automation Add-In to replace Excel macros!!
Help with VB Excel
How to compose a Leave Table in text & color bar?
Merged cells width
What format are files saved in when printing to a file from Excel
I think this is ridiculous
Variable with no Value inside Macro Equation??
how to tell if a named range exists
Delete blank calls in row, shifting left
Print area Macro
Lotus Notes Stationery
working with a named range
Save As with specific format
Comunicating with FAX software
hide or remove rows
Naming multiple sheets in a workbook using cells within the workbo
Change Olap datasource
comparing worksheets
Sort Each Row seperately
Use of Today() and change data type
Need help with series chart, please
set focus on user form
Programmatically add shapes to a selection
help with a large IF statement.
Unhide hidden/protected worksheets
Add any activex control to toolbar?
Excel (and ASP.NET)
Date/time Stamp?
import all sheets from a closed workbook
problem with Paste-Special-Values from a List (range of cells)
choosing dates on userform
Need some help with some VBA code...
Use counter to copy formulas
Populate a range of cells from a function
People keep doing things they shouldn't on my sheet
How can I merge Excel data into MS Word
Merge/Copy Separate Sheets into One Workbook
Populating a combo box from a Validation
Copy a workbook
programatically retrieve selected rows from excel workbook
Search and Disallow macro in Excel
Can I line up lots of controls on a sheet at once?
How to jump between TextBoxes
Read 500 columns of CSV data into a spreadsheet
Read 500 columns of CSV data into a spreadsheet
link to pdf file & menu bar in user form
Auto Close Excel Workbook
Re: How can I insert a picture from a file into a cell?
Load VB Code every time Excel opens
Stopping User Defined Functions for Recalculating
Managing menus via VBA
Conflict reporting No of columns
How to keep track of opened sheet?
variable replacement help please
version compatibility of excel macros
Create an add-in from a VB module
strange vba interaction
How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ?
Filtering data to another sheet
IDTExtensibility2
Dynamic Ranges/Cells??
colour palette
Getting only value out of a formula
Re: Using SQL to query Excel Data
Log distribution random number generator
Colors
Error message
open browser window at my given location
Color names
how do I animate clip art in Excel?
get data from other xls
Excel, Com, XLL and .Net
Variables
WorkbookBeforeClose event is not canceled
Help with code please?
global or local intializing ??
Linking Textbox and cell
Msgbox on spreadsheet launch
RE: Navigating between option buttons is not selecting the option
Macro to Delete empty columns
Offsetting a varible??
Insert Image on a form
Excel Macro workbook_open() BUG with addins?
Long shot - bookmap
matrix columns to rows
Record Selection
want to link excel doc. to pdf.
open 2 files of different signature
Having problem adding up column wondering if HLOOKUP is the cause
Making pictures global
specific worksheet can't be constant?
unload an add-in from an Macro
New user help and Excel read question (Interop and OleDb)
Why doesn't the font color change?
msgbox appear with error msg
Another object defined error!
deleting sequential numbers
BeforeClose vs Auto_Close
Macro Wait command
Re: Macro Wait command
Search Form
R1C1 reference to worksheets?
Sending mail from Excel
RefEdit on Userform to pick up range in another workbook
ADO - closed workbook - Named range
RE: Navigating between option buttons is not selecting the option
Re: Sending mail from Excel
What am I doing wrong....!!!
Worksheet name as part of Data Source parameter
sumproduct and conditionals
Need macro to open a variable filename
Handling Errors and MessageBox
VB.NET 2k3 and Excel Add-In
Cant use this protectio method in a shared workbook???
VBA Help Contents Won't Show
Linear Interpolation
Can an image be inseted next to text on a button?
Find Value in Hidden Cells
Macro code that will look for the most recent workbook
short version of Index/Table of Contents
a small question
Getting values from a dynamic userform
Embedding Images in Excel Workbook
variant and currency decimals
Inserting Value from one cell to another
Deleting blank rows in a range or another fill approach
Macro to populate next empty cell?
Recursion
Variables
RE: Connecting to access
Help with Loop Until
Exiting Multiple Subs?
Extracting Pivot Table Grand Totals
Automatic date or time in forms
COPY WORKSHEET WITH VALUES IN CELLS BUT WITHOUT LINKS
Option Buttons and colors
vb6 form with listbox
Display a textbox embedded in the Excel sheet
macro in excel
Target As Excel.Range or Target As Range
Excel 2003 VBA Question
VBA Code for Email
Macro with rolling database
compare sheets (values and formulas), alert it like spellcheckers
Automatically hide or delete empty rows after IF ?
PivotTable too big??
refresh data command message
semicolon delimiter in a cell
Office 12 will be different?
Making writing not print.
repeated screen "blinking" problem when running program - please help!
SQL Server Connection Pooling
SAVEAS OR MOVE VIA VBA
Date Format Issue
Date Format Issue
refedits in a userform control class
Limit on Excel 97 file size?
Data validation/Formatting input
PDF file creation
still can't find xlodbc.xla
copy sheet
Changing a Formula Variable
Position To Start At
Find - VBA
Activate method of OLEObject failed
Unhandled Exception in Mso9.dll when Using XlCoerce with Excel 200
Macro for Excel and Word
52 Bad file name or number - when reading file from FTP
Excel VBA Beginner Books
How to add data to ColumnHeads of Listbox
Using Classes in .xla
enable/disable start button on basis of chkbox conditions
Re: Problem in PasteSpecial function
On Button Click(Help!)
macro runs counting
Copying Sheets Between Workbooks
can v lock column
Help with Multipage Events
UDF categorisation
UDF Help/Comment
Import filter and update master
Print button on a msgbox
Email macro
Looping thru files extracting data
Re: Connecting to access
Copy function with using criteria
extracting from excel spreadsheet and creating several files or sh
Extract from subtotals
syntax difference between vb and vb.net
Macro Filename as Date
Array output and comment
Catch column width event.
select case statement
Crappy message when using the "recipients" property
Printing to PDF format using CutePDF Writer in VBA
MsgBox - place and size?
International Bug in Excel Solver
A macro to append text to cell content
Read and Write Excel file
VBA and #N/A
Call File Browser ?
How do I specify certain column to count rows in it?
shortening a macro
Worksheet lookup
Using a variable to set a Range
can a User Form reference several sheets?
How to split filename from filepath?
Too slow testing
Update Charts using VBA
Setting up a series hierarcy with a pivot table
parameter problem
How to save a wordart as METAFILE?
How do I link Multi Columns list values to different cells in VB?
Counting Cell Characters
Disabling Save Upon Exit
autoamtically hiding a column after moving to a next cell outside
Control not installed on this Machine error in Excel 2000
Export as HTML Macro and other odds and ends
OnAction - Adding a command bar
Excel Macro - Help!!!
Save as HTML
drop down list
Form VBA
Help with VB Call function from Excel
Preventing Users From Saving An Excel Workbook
Run Macro From If Statement
Re: Run Macro From If Statement
Format Text During Function
preparing/transferring data to database
Excel /vba / computer IP address
Excel /vba / computer IP address
HELP - How do I determine my computers IP address through VBA in Excel
How Do I Use Lotus Notes Stationery?
alternative to TextBox1.Activate
Help with Pivot Table
Send worksheet to text file
Excel trendline - get the R2 value by code
private sub
Must Be Missing Something Obvious About ListBoxes
Does querytable work with OWC11.Spreadsheet?
How to assign a variable in a range select
Saving an EXCEL spreadsheet in fixed length format
Unexpected error 1004 when using workbooks.open
How can I create a custom data form in excel?
Creating Help within functions
Selecting a Range using Inputbox Method
Convert Excel sheet to PDF
Reference to Word document
Skip cells with Tab/Shift+Tab
AutoFilter
worksheet protection excel 2000 vrs 2003
How to insert page number and number of page.....
Carry range names into copy of template
VB6 form show Minimize button
UserForm Title Bar
Locating a user's Program Files
Is there a way to insert a word document into a single excel cell
How to write a vba loop for Excel
problem: when paste => validations lost => excel corrupted !
Button using Form, Iteration and Input values
Re: random number generator
digital certificate being discarded from a shared workbook
object is closed
Assistance in depth on class module for excel vba
cell formatting - apply borders
OLEObjects.Add strange behaviour
Another UserForm Ques.
How to get list of emails in Inbox with senders name and ID?
Sequencial numbering
CDate and IsDate
% in Filename
Need 'save clipboard' property of 'Open file' function.
Message box [how it works??]
HELP - How can I protected a excel file to specific computer
populate listbox?
URGENT: switch excel workbooks and display msgbox
excel, vb arrays and perl
Scroll wheel in Excel VBA editor
Any good book/Tutorial on COM add-ins for Excel
how do you open a file read-only?
How to write a macro to open a file read-only?
How do I get a macro to ask for a 'range' to go to with a choice of Named ranges?
Worksheet 'on Change' event
Changing the font color using VBA
What's wrong with this?
Outlining -- VBA Macro Package for Excel?
Automatically enter today's date as a static entry
Picture in Body . . .
Multiple Ranges for Combo Box in Forms
Can this be done
Cell Protection
nembers to text
Accessing FTP through VBA Macro
Delete Tab Formula Problem
Using commondialog.showopen
After each new dll compilation I have to set the reference to the dll in Excel again.
run a macro ..
array of userform controls
run outlook express instead of outlook?
Spreadsheet 9.0 Control
When using worksheet.hyperlink.follow .NewWindow:=true
How do I limit Input cells in MS Excel
Create a hyperlink to a hyperlinked cell using Vlookup function
Help with vba and Headers needed
Excel open an Outlook e-mail?
Re: result on a new sheet
Excel Macro
Pairs, Triplets, Quads...
Not going through all Conditions
Aging Calculation
Can this be simplified?
More File Attributes needed
Importing a large txt file
class modules and array
Formula in VBA
template
Conditional formatting code wont work
Re: Formula in VBA
Re: Formula in VBA
Not Looping Through
Problem with Formatting Textboxes
Re: variable range
Merge Worksheets and Keep Format
Re: variable range
problem with saving a workbook using VBA with the file is open bef
Access Query with Password
Countif
open workbook using wildcard
Buggy VBE behavior
Editing Textbox After Format??
Increasing Excel stability?
Need VBA Help in Copying Range
Pulling data from database
import sheets of name selected
find cell location of max value in column
Get Addition of each Column in a sheet
randomize, grouping, copying
Pressing a button using a macro
Re: a way to color the CURRENT row or cell when selected
Balloon button
HyperLink Exception
Sum of a Range (with a twist)
Sorting and Summarizing data
Using VBA to create a Networkdays function
Selecting Button Just Activated (help!)
Scrolling Text In Excel
XML Source
loading ocx file.
loading a ocx file
Excel XP Add-in problem with network shares
Protecting vba code better
Using a cell's contents as a reference in Macros
Help: Can't write to the right sheet
Varning! Virus found on this group!
Virus found on this group!
Varning! Virus hittade i denna grupp!
Varning! Virus found on this group!
runtime error 1004 paste method of worksheet class failed
Get number of columns and rows
Fill property
Copying data to specific columns
Remove Hyperlink Path Message
RE: Record update date in cell
Record update date in cell
inputting text on Word document using excel
Vba goal seek
Macro won't run
Active cell, row, column, worksheet, etc
Declaration name
This code won't work, any ideas?
Multiple variables
xml/Excel column order
Named Ranges in external Data Sources
Opening Word from Excel
Help with scrubing two list of names
DeleteDuplicateRows: problem with this macro
Help! Range("startsum").Value = Application.Sum(Selection)
Call a macro in anothe file
Sub name issue
FollowHyperlink Method
Changing color conditionally
ranged name without "worksheet"
Workbook_BeforeSave ActiveWorkbook.Name Error
OR statements
Acknowledgements!
Fixing a Macro-related Crash in Excel
Shorter method to "box" some cells
From String to Long
GetOpenFileName with F*.txt
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells
Data Validation Numbers and Text
WindowActivate event wrong
Adding a Check Mark commant to the Menu
Macro showing Offset instead of Ranges
If...Then Problem - bringing up wrong info!
check my code - big ask
Cancel Button in Open File Window
Extract 2, 3, 4 or 5-digit number from string
Extract 2, 3, 4 or 5-digit number from string
Range Copy
formula construction w/ vba
Time capture problem
Masking on TextBox
Application.OnTime -- Unable to Pass Macro with Numeric Parameter
May be Automation AddIn loading problem!!
Automation Error
how to set a variable to a Chart? not ChartObject
how do i design/ implement a spread sheet to input live data
Forcing Excel Closed
Menu customizations affect all workbooks?
Copy Paste from Active cell
get values from one sheet and add to another
Pasting after Workbook Activate event
clearing array contents
VBA Conditional Formating Problem
How do I write VB to run Macro when sheet selected?
Call Oracle Procedure from Excel macro
Assigning a color to a cell
Delete rows with specific text
How to Pass Control from VBA to user and return
turn off autocalc
Method 'Display Alerts' of object '_Application' failed
get rid of mesage boxes
Calender Issues
Date Format Changes on Copy
formula construction II
select sheets
How to prevent a specific worksheet from being printed !
"if, IsError,Cell & Formulas";giving error message when cell is #R
Userform lookup date value in database
make a staff rota in excel
Excel Charts + VBA: Changing y-axis Format
How to select checkBoxes as a group in
How to Clear all Data on sheet after a given row
splitting data in a column
Copying Multiple Columns
AUTO FORMATTING WHEN ADDING ADDITIONAL ROWS
selecting a range
find and delete rows
Need Code To Print From Code Modules
Need Code To Print From Code Modules
Sub or function not defined.
Last Cell Accessed
I need 4 condition for condition formatting
Protect sheets
Action on sheet Selection
Password in a combo box
Re: Action on sheet Selection
Emailing a form from a spreadsheet
Utility required - probably already invented
date/time question
Worksheet_Activate event clears clipboard?
how to "delay" formula's calculations
Can this be done?
Select multiple rows and add a value in a column
Custom VBA took 0.0625 sec is it too slow?
Comparing sql record to cell value
Macro calling another Macro
Macro to tell if Cell is Text or Number
picture scrolling?
Footers in which number of characters exceeds 255
VBA Query to Excel, Stuck.
Changing the Worksheet ScrollBars Color !
Autofilter including incorrect rows
Macro to know if Cell is Text or Number
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error
refer to dynamic range in closed workbook with ADO
store chkbox.caption in array
external data (detailed)
Application Function
Q. How do I code a column to insert current date, when I double-click?
Forward planning (networkdays without last 2 parameters)
last row in ANY column
Supress Query Refresh dialog on opening workbook
Activecell - Probably very easy question
change audit
easy question about FaceID
I have a VB related question,...
Comparing double values
Calculating Averages
Auto filter and Next Row
Language of the local PC
Can't get CF to work properly, Active Cell problem?
Working with 2 workbooks
Range Question
Arrays
Save without VBA code?
Where to sell custom apps?
Password protection
Where is the timer activex control in MS Excel VBA?
Worksheet feature help
Fibonacci function/command in excel?...tia sal
Lookup multiple values on multiple sheets
Re: Worksheet feature help
Re: Worksheet feature help
Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
Simple Question: Select Text Box from Spreadsheet?
First double-click lost?
Save As macro
Overwrite Master sheet when using merge macro
Trouble with VBA data assignment
format question
telling VB: if cells(a,b)="any number" then ...
How do I synchronize two similar Excel files?
How to Create an Excel file?
Editing controls after testing
In Operator Equivalent
Place code from current workbook to new workbook
Checking File Attributes of Excel CSV over Inter/Intra Net
For Each in Range
Array loses data type when placed into range
Clumsy VBA Code for Chart Source Data from Loop
Using a cell value as the subject line
Resolving percent and date formats as such in concatenate function and emails
remove all hyperlinks
Macro Question
data validation
macro in vba to display autoshape
How to "show all" items in a Pivot Table via vba
.PrintTitleRows
How Can I Prevent Data Entry In Same Category on the Same Date?
Error, Worksheet Will Not Open
Updating multiple layers of links
Days in a month Function
exporting CSV numbers become text
Extracting value from Combination drop down-edit box
Microsoft query issue
x in checkbox
Auto Excel workbook close: save= false during an auto subroutine
Subtotal Column Labels error
Renaming File Statement -How does it work??
Running an Excel Macro as a Scheduled Task
How to convert xls to plain ascii text.
Summary sheet in a workbook
Close Visual Basic
Renaming sheets from a list
Duplication
excel conditional formula
Send To Mail Recipient
ActiveX Control Events dropped | lost | blocked - Excel / VBA
Workbook_BeforeClose event is not canceled
Sum a lot of box in different pages
User Form
Color of cell.
How can I copy cell content to a text box?
Creating a toolbar
template 4 proj cost analysis (sales value - expenses=profit)
Excel crashes after quiting
EnableOutlining with shared workbook protected sheet?
Hooking TIB R/V to Excel 2002 RTD
Is there a NET-Control in VSTO similar to RefEdit?
Class Module & Module
Sending Userform data to different sheets
Supressing the Macro security message programmatically.
Double Numbers
Freeform shapes
Shrinking Listbox
Application.Interactive=true ignored?
Delete Macro from VBA
Excel to Word
excel to html
Importing an Image (jpeg) in Excel
Macro doesn't run on new machine
how do i change font size in msgbox
Delete a command button via VBA