Microsoft Excel Programming

Export Chart to Microsoft Word
Error 1004 when running on a protected sheet
Re: Inputbox() Sum() MsgBox()
Custom Toolbar
Merge cells with information
Sorting and inserting problem
Re: adding to a number already in a cell
How do you get a macro to run upon opening a SpSheet
Re: Conditionnal formatting using VB
Strong-arm tactic for enabling Macro
UDF's and Worksheet Function VBA Combinations
a picklist for a field
ResizeArray for Alan Question
Directory Printer
Trim characters
Re: Cell address nearest to screen coordinates
long if statement
Who has a workbook open
XML exports and style sheets
Change the background color on a multipage control?
AUTOMATIC DELETE
copy & paste from & to hidden sheets
Re: insert SORT in right-click
Left Justify Caption on a Button
Same Footer, but different page setup options
XL 2003 Customized AutoFormat
Switching Workbooks in vbscript
Code for moving cursor one cell to the right
Excel VBA Forms and multiple checkboxes
VB Code does not work when sheet or workbook is protected
Web Query & Array Questions!
RE: worksheets formatting
Problem with UDF can't return the value of a formula
Filters/Range/Summing
AllowFormattingCells in Excel 2000?
RE: default references or adding programatically
Best Book in VBA?
Load Excel worksheet displayed in IE into native excel
RE: ComboBox control behavior changes when BeforeUpdate event hand
Conditional Formatting
Invalid procedure call in use of Shape property??
Re: Hidden rows
Align a picture/shape in the middle of a range("A1:H10")
Align a picture/shape in the middle of a range("A1:H10")
Macro to find the next free line
Rounding Errors
Macro for pivot table and printing.....
Re: VLookUp when Macro Opens WorkBooks
RE: VLookUp when Macro Opens WorkBooks
use a variable in a formula
Re: Selecting Multiple items in ListBox
stop code execution
Macro for Date & Time
Hyperlinks from Bar Charts
Drop-down updated on each keystroke
Is it possible to use a Lookup Table???
General question about organizing or grouping AddIns
FileFormat for "field1", "field2"
Re: changing column order in pivot tables?
select mulitiple columns and items from a listbox
Re: VLookUp when Macro Opens WorkBooks
make macro change (delete) its own code
run-time error 9
Unable to remove Sheet objects in the Microsoft Excel Objects
Macro to delete rows with text cells
Freeze pane of all Sheets how?
worksheet_change
Looping Find Next
Finding from a range
Run an excel macro without tying up excel?
Checking for who opened Excel
dataform
ComboBox - Entering Text
Run Access query from Excel
Re: Bypassing startup macros
workbook open read only without prompt
Finding if the activecell is withing a named range
Initialize variable
Referring Date in VBA
Data Form Insert Count to add to Summary Sheet
Re: Bypassing startup macros
How do I determine a Function's callling Row Number.
How to know the total number of records in the excel sheet
Do not print in duplex
Hide Columns w/Change Event
Newbie- Filename referencing in macros
Selecting cells from a list
Copying Data
Newbie: Error 1004
If statement
Importing Complicated Access Query into Excel
Option button caption
Printing Problems in a big Excel App
cell contents as filename
Method Rows of Object Global Failed
Huge Excel Document
Re: Toolbar on opening a workbook
cancelling out of read-only recommended locks up Excel 2000
Refreshing Query Tables
Putting correct values in cells
Hide Columns w/Change Event
Re: Refreshing Query Tables
How to check "Always trust macros from this published" when securityis set to high?
Re: One more question on ListBoxes (I hope)
Damsel Needs Assitance with Proper_Case Macro
Protected Projects
Macro Folder
Pre defined value
VB Code exploded in size - suggestions
delete macro with code
Re: Having input the current date in a cell I want to lock it
Fixing UserForm Position
Excel VBA - Creating Directories
macros not showing up when using excel COM object in .NET
Listbox Usage
Text Cell
Locking a project
Re: How can I....
Re: Best Fit Solution
Extract Characters
Re: hiding rows using macro
FolderPicker dialog box
Returning varying rows of data through lookup function
change tab name
Bitmaps on User Forms...can you make it a jpeg????
Re: VBA to find Cell Range in Files in Folder, return value
File Not Saving
Using builtin sheet activator
Personal.xls
Re: Personal.xls
Rounding Defect?
TextBox not responding...
Re: Intellimouse Wheel Event
Cannot copy a sheet
Re: Having input the current date in a cell I want to lock it
Asc character
Can someone work their magic (Good SS that I wish to make better) - Lancefer's Pop ME '03-'04 Temp.zip (0/1)
Finding Matching Records in a Column
Re: Need VB Coding Help for a Macro
truncating a number in VB
Re: Need VB Coding Help for a Macro
Creating a chart in C#
Macro moving down the sheet cell by cell
Adding control in VB
Code Help
Link to Public Folder Post?
help in showing results of database query
vbCode to Link a picture to a user form rather than embed it
Populate Listbox with File Name Only
Format Same Length Always?
Macro to delete rows
Re: Intellimouse Wheel Event
modified time of a worksheet
Using "End" to stop all code
insert 3 rows before any text in column A
Extracting a dynamic range
Sorting data and retaining additional information with value, not
Error in macro, that opens a file!
Calculation of peak and off peak hours
Change the File Open option in Excel
Macro doesn't work in Excel 97
Re: Having input the current date in a cell I want to lock it
Left/Right Header/Footer Text Margins!
Calculation of peak / off peak hrs v2
Convert to PDF
how do i have multiple inputs and 1 output
Excel VBA - If Else problem - HELP PLEASE
XL VBA adding new worksheet if current worksheet is not empty
making a group visible (or not...)
Macro to change text colour
Evaluate or WorksheetFunction Problem
Disable item
Simple Q about font color
Help
Detect Password Protection
dynamic data lookup by cell
call excel macro from access
Stored code
List unique
Comparing two lists
Qn: vbOKCancel -- Cancel doesn't work??
Qn: Setting MultiPage page default???
Excel 97 ADODB Recordset.Find "Invalid Use" error
Any easier way than looping on ranges
Cell Change
fso.FileExists is too fussy
One works - One does not?
Excel 2002 VBA connection to Access 2002 using SQL
NEGATIVE HOURS (2)
Protecting my macros from being viewed/edited?
Application level event handler broken in 2003SP1 ?
formula help
Change back round color of a cell w/VB
arrays in arrays
Can't browze and open file, urgent!
Automated charting VB code problem
How to?
Re: Creating directories from excel
can't do Find or Replace while Modeless form is shown
"Last modified by" in a cell.
SelectionChange or Defined Name Selection Difference
Directory contents
msg box while operation is running.
Options in Cell
Querying data from an outside table
Offset Between?
macro to update page footer number
Errors on other PCs
Excel.......Automate importing multiple changing CSV's
Use Keyboard with Command Button
Forms
Re: Nested function 'FIND(OR)'
Re: How do I use tabs in a macro?
Re: How do I use tabs in a macro?
Saving txt files and date format changes
Master List
Copy/Paste Macro and Column Sizing
Cut cells from column A that contain "/" Paste them to column B
Linking userform to userform in Excel 2003
Macro it's very Slow ....
VBA Form Drop Down List
Re: How do I use tabs in a macro?
macro question
Save files as different names
How do I use tabs in a macro?
Installing Add-in for all users in Win 2000/XP
Copying a chart
Formatting all worksheets to fit on one page each
Auto create unique accelerators for a list
Make more than 1 selection from combobox send to another sheet
macro advice
UDF not available
Missing something? does not count correctly
Running Macro from objApp Application object
Copy data
Step Thru Formulas Macro
DateAdd
add-ins
Macro to open another workbook
Excel Question
Problems opening a text file using macro!
Import PDF
really simple question
Excel 2000: How to execute code automatically?
MsgBox Prompt w/ No "X" to close
Please Help with a macro.
Re: xlodbc
Running a Macro from hidden Workbook
Excel - Customize Default Color Palette
Open or Show a Message Box on open...
Data Validation
Starting Inputbox focused?
How can i set up the alerts on the desktop ?
Are all the old posts gone for good!
Date format in macros
Deleting Macros
Find word and copy
Autofill last row
Referencing Code from another project
writing a formula containing if and and
Copying sheet to another workbook using VBA...
Excel's Sort Order
RE: replace a formula with it's results....need help
Re: Histogram
Help with Reducing Numbers Please
Selecting a Range of cells in VBA
Question about opening workbooks on Excel startup
Re: Excel/VB Copy/Paste of Graphics
Choosing a directory/file
Counting Values
Pointer required
Cell Naming and Formula bar Display
Print area
how do I delete a workbook
DO YOU NEED MONEY HE/SHE READS THIS I ARTICULATE???
Qn: SpinButton1.Max not working??
Re: msg box while operation is running.
VBA Code to switch view
Checking if autofilter is on?
Reading conditional format that is active in VB
How to optimize and improve that code ?
Initializing static variables in VBA
Check cells in a column
peek and poke using vb
where is the _IMsoDispObj
how to connect to already open excel sheet
Macro - Run automatically every X minutes
almost works
Vba - getting value from other userform
just testing
Excel VBA
Re: Histogram
Removing characters from a text string
open word document
excel VBA
Verifying lines with other workbook
copy from a list
press letter and go 2 entry begin w letter in data validation drop
Programing Dialogs in Excel 2002
Programing Dialogs in Excel 2002
Please advise: excel's mathematic solutions
sending email from excel using outlook express
Comment extraire et traiter les donnés GPS
making new wkb and place an event in it
auto run macro at workbook open
trouble linking formulas, because format continues to change
Filter Listbox in user form
new message scroll bar missing
Is it possible?
Method 'Range' of Object_Worksheet Failed
how to create a cumulative distribution
Can you Limit the number of caracters that can be typed in a cell?
checking if file is saved
How to create the URL with link using the VBA form input in excel?
How can I create a URL with link using the VBA form.
TEXT TO COLUMNS
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form?
VBA macro to obtain file names using WIN32 API
Clearing TextBoxes needs 2 clicks
Lost Focus - Applying to cell
To reformat a culculated date/time round-up to the nearest ½ hour
Worksheet functions in VB
how to add items to combobox
matching dates from imported *.dbf file?
worksheet function in VB
Not sure how to handle this
Missing a library in menu --> extra -->references
Excel Macro Query - Search for specific text in cells of a column
protection with password
ListBox "picking the same item repeatedly"
Sending Excel Data to a Coldfusion Form
import simple data & re-arrange it
ActiveCell.Formula
RE: mswinsck.ocx
pls help newbie with my significant figures function
VBA, How to open a file with date like 29 August 2004
Microsoft Office Word has encountered a problem when shutting down
VBA - Closing Outlook
HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
Sorting Using Code
Importing into Excel
Runs possible on the background?
Reading from an Excel Document
Protect worksheet
can we add a blank line after every...lines?
Resize Range Question
more newbie help on my significant figures function...
File Open Take a Long Time
Excel User Group, Sydney, Aus
Help with my code and formula
Read from an Excel file
How to create controls at runtime
Trim: Excel 97 gives error "Can't find project or library"
Possible to write VBA code to send out an EMAIL everytime a workbook is opened?
Calling Microsoft Excel ODBC Query
Mail from Excel 97 via Notes 5
Macro
Selection.AutoFill Destination
Selection based on coloured cells?
GetSaveAsFilename - Save as box
Header/Left margin
ComboBox
SpinButton Controls in Excel 2000
Validating from a list workaround
drawingobjects what is it ????
Lookup external data by cell or range of cells
Need help with figuring running totals
Little bit of Java in VB?
ambiguous error
Need macro that selects an item off pivot page filter, prints, se.
Watch Window
Importing a txt file to a ComboBox itens
ActiveCell.FormulaArray code - Get error
Checking Cell Background Color
Get Word to the foreground
Rounding problem (controlling word from excel)
Help with grouping values
Pasting in a unique row for each unique date
macro
linking to web page
Newbie Help
Expanding Selection Range
Adding a drop down list
Excel Functoin getting Cluster status
Re: How do I open a Form in Excel XP
multiple cells in a loop
Re: Programming to VBE
Macros not getting updated in personal.xls!
Re: Programming to VBE
Referencing specific cell
Pivot Table Grouping
Re: mkdir problem
formatting cells
Re: Programming to VBE
QN: Webpage Hyperlink in a UserForm??
dropdown lists
Export range to text file
Re: mkdir problem
Start VBA with a macro?
Line Broken Transfering data to Word
NEGATIVE HOURS (3)
Best way to add Multi selection box
Excel VBA - Printing a sheet rotated 180 degrees
Re: Formatting toolbar
Re: Macro
Function, Calculation of Standard Deviation of levels
Re: Rounding Time
Saving a woorkbook as a TXT file keeping its current name
WorkSheet.Delete
error: "sub or function not defined" what is it trying to tell me?!
Courtesy
Import Data
Opening a Database from Excel
How to get Row & Column in Excel 2000 VB?
Log File using VBA in Excel XP or 97
A question about Cells & finding the Week
Msgbox
Best approach to this problem
Find exact values
Displaying a message when macros run!
opening multiple files from within a macro
Database Connection from Excel
Named Formulas-Excel Modifying Them
Re: Nested Subtotal and Macro
Re: Workbook_BeforeClose
Question for Alan on QuickSort
multi selection list as text?
sheet reference
Private Sub Workbook_Open() not running on open
Type mismatch error
Reason for past posts being removed
DELETING BLANK ROWS
EventClass Module
ActiveWindow.Width no longer works for me!
Excel macro: Speak on enter
Update cell values after cell is changed
Displaying Formulas and Values of the Same Cells
Sub or function not defined error
Update Links
Re: Change list to hyperlinks
noob: problems with macros in invoice
Looking up blank cells and transporting data to another worksheet
Rename Worksheets to Sequential Dates
Setting up a formula
formula to see if cell contains one of two text values
TimeStamps
how do I update a spreadsheet without duplicating records?
Object Hierchy
Re: Change list to hyperlinks
Re: VBA-writing a macro
dumb question
Runtime error 1004 with method OpenText - but only on one computer
Can I split&write data to each individual sheet?
Initializing Userform
open & save old xls file
Re: Macro - Format Spreadsheet
Macro to move the cursor to a different cell on the same row
How to apply conditions on Input box?
listbox saving ?
Re: Help setting a print range in a data sheet
Re: Help setting a print range in a data sheet
Vlookup in VB not returning anything error
view datagrid report in .xls or .pdf
ListBox ( finding supporting data not in the list)
Mk Dir
Acquiring a single recordset from Access into Excel
pivot table+put unique data in 'row area'+count of items in 'data area'
ListBox (finding Repost) (try to line up my example)
When i close a object 91 error shows.
Re: Locating Cell data and corresponding Max data
Excel 2003 multiple regression coefficients inaccurate
Is there a way to simulate a 'Hide Column' Event?
Order of open/close
Recording a macro to open a large fixed-width text file
worksheet save
Excel – Macro Problem – Find/Search and Insert
Macro for Excel page Customization
Randomize three variables subject to sum always equal to 1
closing a userform
Re: Randomize three variables subject to sum always equal to 1
A1 style Range in programming
Macro to hide multiple rows
Excel VBA - Problem calculating and passing values to another worksheet
Takes long to save the file (Speed problem)
can I sort colored cells?
Moving between textboxes
About Page Break
Identifying the Last Column in a spreadsheet
Does Excel Support Java?
Can't find project or libary
SOLVER- programming or not?
ClearContents - Except NamedRanges
identify 'save as' of the commandbar 'worksheet menu bar'
Read excel data programaticaly in C/C++
Missing Post
Error when trying to use QueryTables.Add
Sheets arrays
Signing VBA code within an Excel spreadsheet from VBA
Color Cells via VBA
Re: Referencing cells in another workbook
Re: Referencing cells in another workbook
auto-fill information
Re: Protected sheet
Excel VBA Write to xls ?
Excel VBA Write to xls ?
Re: Deleting nonactive Sheets in Excell
direction needed
Re: Deleting nonactive Sheets in Excell
Addin working on all sheets
Variables
Incorrect column expression
Would a loop work?
Re: Protecting the code
find, Match, Copy from onesheet to other
Comparing to Arrays
Average of one range based on date in one column
Deactivating worksheets
Excel / XP SP2 / Web
SQL in Excel Query
Import Dropping Leading Zeroes
Run Time Error 9
Re: Calculating a auto filtered range
Import Data
Subdirectories
Apply conditions on Input box continuation!
Path and File Name
Having file name on the excel sheet automatically
Installing a button with VBA
Excel worksheets and VB .NET
Shell command in VBA suddenly stops working
Re: searching for vlookup equivalent in VBA
If Cell1 has something Cell2 is blank?
MsgBox & String
form wont show or load
Userform Info
VBA File in EXCEL 2000 Crashes in code that I have made no changes
Re: Reserved words in Excel VBA
Declare an Array() ????
epxort to excel removes trailing 0's
MsgBox String 2
cell/column referencing and plotting data
Re: Comparing to Arrays
Re: Comparing to Arrays
Re: Comparing to Arrays
Visual basic Userform caption
Timing problem
Public constant in many workbooks
Open workbook and paste formulas in another
MsgBox & String 3
Google search from excel
Changing range names in VBA
Picture Editor for Excel
Turn off file numbering
finding the last cell with content
Re: Comparing to Arrays
Macro query - finding mutliple occurences of text in a column
return a value from a dialog box
Automatically include contents of a cell in "Save As..." filename.
number vs text format
formatting in a protected sheet
Type Mismatch error
Cancel option possible while opening a file?
Re: Comparing to Arrays
path to current file...
Tab Order for an Excel Form
Re: ADO
links updating
sql connection in macro
Tabs
MOD function
QDE (Quick Date Entry)
pass argument to macro
Passing a String in Array to Range as String
Format cell
Highlight a selected toolbar in a menu!
Re: Error Converting Passed Range into Array in VBA for Excel
Re: ActiveWindow.Width no longer works for me!
Group items
Call subs from another wkbk?
Multiple row selection
Chart size/position
Deleting macro code programatically
Excel to VBA
Combo Box
Writing to a closed workbook
Delete an Item in a list box
Select/Copy/Paste in Macro/VBA
A bit long - but please help
How to query the controls in form using vb
ENTER DATE, CHOOSE WKSHEET, SAVE IN FOLDER
Worksheet_Change wont Trigger
AUTOMATE DATE SELECTION, PRINT, PDF
How can I use Analysis Toll Pack functions in VBA?
Static Macro in Spreadsheet
excel fit to 1 page shows 1 page but not all data is on that page
select a list from several worksheets
Do combobox allow user to enter text?
statement for.... to
Excel as a service ?
Passing Worksheet tab as an argument.
Re: Looking for books on Pivot table
track cell changes
Macro to run on openinng worksheet
Excel Formatting Cells Using VB code
Adding module - assigning macro to button
Workbook Open - Prevent CTRL Break
Re: etyping difficulties
Goto Command in Code
Populating Column Headers in a ListBox
listbox default datatype
Best fit
Macro to delete line
Filesearch : .zip files not found ???
Protecting values of variables
typing difficulties
Syntax when referring to self
copy cell contents to a textbox > 255 characters
Help!!!
Re: VBAProject Password
Looping through (active??) cells problem
Word Wrap
Excel 2000 to excel 2003
Entering Array Formula
Checking range names
Assistance in VBA
Do not want sheet renamed
putting in todays date
Highlight a selection from a menu, urgent!
Range.GetEnumerator() from .Net
Retrieve variant array of cells as formatted in the cell
Mod operator
Saving a chart as a JPG file
Using a macro over a number of sheets
Linking a multiple page spreadsheet into PowerPoint
populating listview with array
Re: Find a cell when Excel opens
Re: how to call a function with variance which is function Name
Re: stop screen refresh
Selecting row data for chart - Not sure what I did right
Re: stop screen refresh
Behavior of Today()??
Batch Open and Save
Re: stop screen refresh
Re: worksheet last updated
Can you "duplicate" "copy" listboxes and code to multiple cells?
Re: Color a cell
Code Centralization
Re: Color a cell
Insert Row without Selecting
Re: Formatting in cells
Interfaces for VBA Forms
Filling Database Query
Excel VBA -- Finding last row in group of columns
Re: Error Converting Passed Range into Array in VBA for Excel
tab direction
Re: Removing macros using VBA
Re: Removing macros using VBA
Re: Removing macros using VBA
XL2003 VBA Add msoControlButton BUG or Feature?
Re: Function Argument
Custom Toolbar position
Scroll Wheel not Working
How to "translate" that in VBA ?
Could not load an object
msgbox (2 questions)
Better Way to Use OptionButton
Trigger an event on Checkbox change
Validation with offset range and other?
Open hyperlink in new window
Use of Indirect function
Re: Better Way to Use OptionButton
Finding a series of values within an Array
application.worksheetfunction. <function> (syntax)
autofilter
Arrays and Strings
Using a macro over a number of sheets (Redux)
Providing Estimate to Complete Info on a Process
Re: Finding a series of values within an Array
Custom Toolbar
Loop to Next item in For Next on Condition
Filename has Url in file-save dialog when saving exported Excel do
A stopwatch to record time in a cell
Re: Finding a series of values within an Array
Macro to Find Cells with Conditional Formats
fill row color on a specified worksheet
null text box
Removing Workbook_Open code
Re: fill row color on a specified worksheet
Re: Removing Workbook_Open code
Row Deletion
Creating a Function
Re: Finding a series of values within an Array
RE: Trigger an event on Checkbox change
Re: Arrays and Strings
Help wanted with computation
max/min of a selected range of cells
Re: Is there a better way (with less typing)?
Re: Is there a better way (with less typing)?
Re: How can I move to another cell two rows up and 1 column over in VB
Insert Columns
Re: 2 spreadsheets
How do I import data into a template
How do I import data into a template
How do I import data into a template
In outlook,how do I show the whole number 5.00 with zeros?
Programmatically Add Worksheet Event
Application.Match
making autofill range dynamic
Re: Application.Match
assign macro to delete event
Log entries, web entries
select range from code
Re: Application.Match
Activate last cell in selected range - an example
Plot 7 bars and 1 line on a chart
Re: Application.Match
Finding latest date
Find Duplicate Entries
Duplicate Records in Excel
make selected item highlighted in listview
Adding a check mark to the custom made toolbar/menu continue......
Invoking a workbook from a Fortran Program!
DDEInitiate to MSAccess problems
Still Having Application.Match trouble
Source of value passed to class object
UserForm collapse ?
Grouping in a chart (Gantt Chart)
Find Unique Entries
Re: Macro written in Excel 2003 and saved as Excel 2000 .xls
Macro buttons
importing several text files into different excel worksheet
To fetch the values from the excel cells into the variable
Standard "Open" and "Save As" Buttons
subroutine to concatenate strings
Insert picture
Multipage control
Excel 2003 VBA Help - Missing Contents
NumberFormat vs NumberFormatLocal
How to make my FORM usable across multiple worksheets?
Sorting data by Cell Colour
Close all other workbooks but this one?
comman button macro can't open worksheet
Finding the current "print range"
code works in excel 2002, but not in excel 2003
What's the difference here?
Way to free memory as I input lines from a file?
Re: Custom Save Button
Find Macro
Macro execution limit
bug listview?