Microsoft Excel Programming

Comparing a single cell to range of cells
Documnet_open() code is not working
NumberFormat not taking
how to use vb to save the excel file
Change the default for a comment
restrict row delition
Excel/VBA Questions
Help on writing code more efficiently (Loops)
Problem using Excel's "Shell" command
Re: Indirect function
Excel version differences
Excel VBA - Wordwrap conundrum
Follow-up to WorkSheet Function
Do Loops
changing a formula range in visual basic
How to use Macro to delete this row??
If Select is the solution - how to avoid Select
Colors in Cells....
Importing LDB (Access Lock File) Into Excel
Copy Paste in Macro
Help Finding the Final Row
Printing a range that is determined at run time
How to sum Values in selected range?
working with tables
Which button did I push
please help with error message
Insert Sheet
Rename current sheet
Concurrent Calls
Dialog box help!
Code to Loop thru a Workbook
Formatting date & time
code that might be causing error - please review and comment
RE: Looping Through Charts
extract text
Re: Indirect function
Looping Through Charts
worksheet
Referencing a cell containing sheet name
More Worksheet and Copy Pase help
excel functions and User defined functions
Solver Macro
Excel/VBA Questions
Excel Templates / Database Backend
FORMATING
Increasing the date with a Macro
Work Underneath a User form
VBA Extensibility problem
Macro to calc an intersection
Add-in tollbar
Make a user form 'un-closeable'
VBA Code
Worksheet Change Event- Refer to Target Address By Name
ADO - Excel - External table is not in the expected format
How to improve this code?
File Search
Personnal certificate problem
Runtime Error '1004' - AddFields method of PivotTable class failed
simple excel vba macro
FindNext
COMPLEX "IF" FORMULAS
excel vba workbook_open event does not work help please
Cells.Select - Why not in a module?
Extracting Colors from Image loaded in userform
Copying only data validation
How do you "Round" a value in Microsoft Excel VB?
Updating Connection Strings
Amending Right-Click Options
How to find *,@,#,$,&,^ ??????
loop through textboxes only
combo box auto refresh
Macro to insert column
Dynamic Variables
importing textfiles with cariagge returns into 1 cell
Timer
Deleting lines in a macro
Counting chars in a string
Missing Reference
Q re: TextToColumns
UserForm: how to print it landscape
ExecuteExcel4Macro: Help with this
msgbox buttons
How to Hide Rows based on conditional value in cell
Link from Userform to Spreadsheet
"1/1/1799" - is a date
Loop
Move them to different folder
Damn error 91!
VBA error - run-time error '1004':
memory
Right Justifying Numbers
How to stop getting system message
Macro to run on fileopen for all workbooks
Convert excel rows into individual documents in word
Calculating
Rowsource not working properly :(
Still stuck
Problem trapping an error
How to hidde sheet?
Various Random Codes not working from time to time
VBAProjects still visible after workbook has closed
RE: Net send
Eliminate screen flashing while running a macro using VBA in Microsoft Excel.
VBA Extensibility
ranges
Pivot Fields
X button at top right of userforms
Userform updating
Excel Macro
translate language using VBA?
Worksheet Change to build product list
Runime Error 1004 Method Range of Object Global Failed
Perconal Macro Book sabotated Excel's work
closing a txt file open in xl
Removing lines of data that do not contain required data (macro)
Macro Help
Type recordset/recordset?
Workbook_BeforeClose problem
RE: Wierd named range RefersTo value
Programming Help
Determine Shift Key Press
Another thing
Identify Comboboxes with Strings?
Column number in letters
searching a range
Automatic Value Calculation
Re: Wierd named range RefersTo value
Macro assistance (might be tricky)
Macro assistance (might be tricky)
Active X controls
key Press on Forms Button
setting properties for shapes
Make Worksheet Event available application-wide
Adding Area Code To Phone Numbers
RE: Copy to wildcard
Change a cells text by another cell changing.
refreshing or repainting worksheet
delete all sheets except...
Save Method
Combo Box Control
Font Size of Option-Button
fixing macro to highlight a row if a checkbox is checked
Ontime event
Supbook
enable disable macro message
How do I convert an integer variable to a string variable?
list for validation
Worksheet Menu Bar
Best Beginner-Intermediate VBA book
how to get a number of rows in a given page?
'Yes' 'No' button on autoopen macro
registering the cell values of excel combo box associated values
Range Names
Worksheet is no longer the active sheet Event
Start a sheet event when i leave a sheet
Class Module
organizing a large amount of data into a table
need to use vba to refer that if a checkbox is checked.. the contents beside it will be copied to another range - to add to excel form
What am I doing wrong? Sending values from one worksheet to another in new workbook
Please help - What am i doing wrong with this array?
Create colums based on a row
Find and read/update option button
whats the difference?
Formula
Personnal certificate and numeric signature problem
excel menubar
Close External Application using VBA
New Menu on Worksheet & Chart Menu Bars
Saveas on Template retains existing name!
Worksheet_Change not updating with vlookup change
Send current Excel File as an attachment using Outlook 2000
VB function to reorder names?
Re: Save multiple sheets in a single html page
Scrolling Marquee in a worksheet.
problem with importing data from access to excel
Progress Bar
Setting Custom Icons at Run-time
Normal Random Variable Generator
Creating Range Arguments for use in function statements
help with templete
Web form validation using Excel datasource?
Show method stops macro
Find Max of Curve Equation
About calling highest level in columnfield
send email through Excel
Send email with alert message
Send email without security alert
late binding in excel
Regarding Crystal Report in Visual Basic 6.0
Form 'Refresh' problem
Help - with macro
Re: Printing Multiple Invoices
Renaming
MsgBox for a range and not one cell change please:
running excel modules without excel
RangeFromPoint Only Finds ShapesAt 0, 0 coordinates
VBA ListBox
Delete Rows - include top row
user defined functions
Programming Excel "drop-down menu" functions
Run a macro based on event
VBA to write Unique Solutions ONLY?
Userform addition question
Last Row Question?
Function for rate of increase re two values
Mapping in Excel Programming
Send Files To FTP - Can't use Internet Transfer Control ActiveX
Total of rows in UsedRange Area
Seemingly Easy Question...help would be greatly appreciated
Auto-fill Acrobat forms with Excel's data
Copy sheet to another specified file
Sub or Function not defined
Copy and move info between files
Automatic Sorting?
Streamline copying and pasting code
Here's a simple routine for LastRow, LastColumn
Populated cells
Copy rows to master sheet
"Round" not found
DataValidationProblem
SaveAs and Excel Automation
Userform Initialization
Logical Comparison of Two cells
Userform stopwatch format milliseconds
Drag/drop - calc of ListBox row wanted
Shell function
SENDKEYS change the "Number Lock" status
Sending Form Focus?
Auto set off for Bank Reconciliation
Excel VBA File Search Command Cannot "See" VBA Project Name
OnTime...Please Help
re complex "IF" Formulas
Year, Month, Days
How Do I Check To See Id A Character Is Present In A Cell
creat a drop/down sub list
Retrieving text being typed and cursor position using VBA or automation, how?
Getting text under mouse cursor
Portability of program in Excel 2000
XLL Add-in help
Deleting pictures using VBA??
filling a two column listbox from a two column recordset
Almost got it Bob- Active Shhet.Picture problem
Sorry here it is again
Excel97 not quit
Getting source lists w/o opening target file
Copy rows to master sheet
How do I show Auto-Filter "Search" Criteria on Sheet1?
Random gen
Code equivalent to the Enter-Key
Declaring a Range Object
How to determine which dynamically generated control was clicked
Creating a For Loop
input form
Scaling
Please help fix my accumulator
Problems with preventing the user of setting a checkbox of a treeview
passing defined name to vb
Goto Next VISIBLE cell below
Any Systems Analysts here?
Sumproduct with text
Changing plot order in series formulas
How many members of the Bush Administration are needed to replacea lightbulb?
Count up
Excel Mailto: subject: body:
Ok heres a tough one....
Treeview control in an Excel form
Range problems
XLL unrecognizable format in Win2000
copy data from sheet1 based on criteria in sheet2 to sheet3
Display first, next, previous on userform from recordset
Countdown timers
late binding in excel
Enable Macros
User CDO for Win2000 in Win98
Using variables to reference columns in VBA
Excel VBA: UserForm Component not Correctly Registered
"Excel VBA - Macro that returns and saves a value in every row"
Passing a named range to a chart/series object
"Excel VBA - Macro that returns and saves a value in every row"
averaging from a fixed point to a non-fixed point?
Anyone has any idea about XF: Extended Format (E0h) record ?
Exporting Excel to XML Spreadsheet or CSV File
How do you copy data from one sheet to another using a button
How to Impot data from a text file to another worksheet.
Re: How to detect if a cell is formula
user form problem
Finding out if subroutines exist in another workbook
Replace function in Excel with MFC
Looking up values in another file
Outllook
VBA Code problems!
Saving text files in excel 95 foremat
starting macros via scheduled tasks
how to confine the range of movement of cursor
Automating the downloading of web page and sending it via email
Multipage problem
Incorrect date format
Using a variabel to make an array?
find problem
Sheet Overflow
Writing a macro to bring back distinct value
Exception when uisng Intersect method
if not used..
Adding a macro to Excel (not to a document)
How to get the row of a specified cell content
Background calculation w/o updating cells
"User-defined type not defined" vb msg
IF-statement??
ListBox
Setfocus won't work on a userform's textbox control
Is it possible to import XML with master-detail data into Excel 2003?
Can a Pivot Table pull data from Multiple WorkSheets ?
Trouble with fields order of imported XML files
"Not" and "Not Like"
startup macro problem
Excel 2003 asks me for a protected worksheet password every time I start Excel
Personnal certificate and numeric signature problem (second try)
Find
looping ... date formula ...
Calendar Control: Can't exit design mode because control can't be created
Wanted func to determine height of ListBox row
Assign macro to button
Sync scroll of two ListBoxes
A table within a cell?
OLE2 Compound file Format
Re: Assign macro to button
Copying a named range / Bullen's PastePicture
Big problem
how to check if a cell is populated or not?
Using VB to change sheet name to match cell contents
Kind of Vlookup
Moving Cells
macro recorder question
Pass multiple parameters through macros
Reference cells in Functions
No Dashes, please?
time compare in Excel
Find and display today's date cel
How to disable screen updating for the Visual Basic Editor
help with excel macro
Calendar Control
Manual Horizontal Pagebreak Report - an example
Zooming of Excel
attendace %
"Can't Find Installable ISAM" error
AutoRun an Excel Workbook when CD-ROM is inserted; Help!
Display files in a directory
Macro Error When Sorting
Calling Forms from Forms - Exit problems
Create Macro - move selected rows to new spread sheet
??Find and Replace Duplicate Cells
Check a cell for duplicates.
Wshshell / VB direction question
Microsoft Query & Dates from Oracle
best way to query during macro run
Linking dropdowns
Using VBA: Avoiding Writing Down Duplicate Solutions
Preventing Users from Modifying Custom Command Bars
Password Brake....
Basic Excel macro problem with outlook
Funcres.xla
Conditional formatting of an autoshape
Excel crashes when attempting to open workbook...even with macros disabled
updating data lists using macros
import external data via macro/vba question
Updating distributed Excel applications
Sending XL data to work bookmark
Open File Location
Popup or Information Message
Excel Scroll Bar
COUNTIF on one ranges with criteria from another
Iterating through an Excel Range with COM automation
VB Efficiency: Inserting a Row
multi workbook cell referencing
Query during macro run
Carriage return in comment not working
Personnal certificate and numeric signature problem (second try)
Sort sheet on sheet's Deactivate event
Macro to cut and paste from Excel to another application
Normal Random Generator
Generate & print reports/forms
Textbox trouble on a user form
Need a macro to evaluate and sift-through data
VB form link
Calander Control
Registry Editing
checking if text changed?
Recalculation
Used Range is not resetting
Workbooks.Open Beeping Problem
Excel Registry Add in settings
Using path instead of drive letter
Sorting rows beneath headlines in another sheet
conditional formatting vba code and calculation
Excel SaveCopyAs COMException 0x800A03EC
Protecting an entire workbook
SUMPRODUCT
Advanced Filter causes excel to crash
Please help: How to make a button to show the sum?
Trapping Data Input with Curser Keys or Entry Key
VLOOKUP
Question about accessing worksheets on an AddIn file
Data available for plotting vs already plotted data
Print *.tif image file from vba excel
replacing spaces?
Re: Like or Equal
automatically gets month in an array
VLOOKUP PART 2....(Dave Paterson)
auto save with variable name with html extension
Use winsocket in excel
Searching For Files with Dates
use MS timer control in excel
how can i change the Drive
formula - average using a count
ActiveWorkbook.Charts.Delete
Help with a Clear Form Macro
Getting a Strange Message from Excel
Check/option
Date and time problems in VBA
How do i place a graphic BEHIND an excel sheet?
Convert function to sub
LoadPicture - how to keep .jpg compression
opening workbook as read-only
Excel VBA assistance for a noobie
Using Events with Embedded Charts
Place Valuse in Cell depanding on another
Convert number in text format to number
Use winsock in Excel VBA
Getting Unixtime in VBA
Delete pivot table
inserting rows on multiple worksheets
Creating a Graph as an Object : Urgent!
Remove item from combobox.
User Form List Box
Macro created in XL2000 not working in XL97
Userform
Hide Excel but show the Userfom ???
COMBOBOX WITH PRINTERS LIST
Load text file and write back
Creating a Graph as an Object : Urgent!
User defined functions
List Boxes
VBA user form
Refreshing a query with a changing date
ListBox
Copy Unique records
Wildcard
TIME CONVERSION
VP CODE
Setting Up Workbook Permissions
loop through Combobox
vb versus cf
conditional format
DefineNames question
Application.Path (Getting the directory that my workbook is in)
Using Microsoft Access via Excel VBA, Houston we have a problem
Form Button
Fastest way of getting data into excel
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet
How do I approach this?
Urgent! Save Excel WorkBook - a special way
Excel Lookups
Used Range Question
Func wanted for drag/drop in ListBox
Maybe OT
Searching values in VBA
LOOKUP finding values it should not
Disable Shortcut Keys
ProtectSharing
Pivot Change event
Conditional Formatting
Force Caps Lock
Need help pasting usedrange in word bookmark
Task Schedule for Macro
Programming for a save button
Comparing lists
Merging excel contents to a Word Letter
Canadian SIN
Create worksheets for each matching values in Column?
Where am I going wrong with this?
adopting a macro to a general situation.
passing defined name to vb
Background Copy Distorted
Loop,Compare,Write
Convert an Excel Spread Sheet to a Relationship Database
COUNT Unique values
Change text to all caps
Using an array in Consolidation
Creating a new worksheet from another
Excel VBA Inputbox Properties?
Macro to Hide/Show Columns based on control cell value
BIG PROBLEM
Help with a loop
using a Named Range (formula) in a UDF
Re: time and date
HELP!! Excel Add-in Problem
Prevent File Copying
Update a shared workbook.
Re: time and date
Modal oddity
Communicating errors from a custom function in an add-in
Compare and delete or return value?
ComboBox_Change sub runs unexpectedly
Re: time and date
Inserting a row
Any ideas?
VBA Identify Workbook
Column resize event
Any ideas?
Creating an XLL with C#
Range question
Sending formatted email from Excel
formatting email from excel to outlook
Copy worksheet and paste it in New workbook, all data except Formulas
must be too simple
combo box close on selection help!!
User defined type problem
Naming a new sheet.
Automatically add new row
VBA
How to find out a string starts with apostrophe?
Instead of using "Clear"?
ComboBox move and size
Operations on .DAT file in Excel...
command button and assign macro
Find and replace the 1st occurrence for many strings
RE: Suppressing or Overriding the OnChange event
Re: Suppressing or Overriding the OnChange event
testing for the name of the file
VB code
newbie: Getting the X and Y positions
ActiveX Control Tutorial
USer Form Entry to multiple cells
Can you query a graph?
format cell based on condition.
Retrieving External Data from Access
Retrieving External Data from Access into Excel
TextBox
setting a range not working, please help
Working around a messagebox
Big Big question
What is the control called in the list option of validation?
Excel 2000 not responding, opening, loading
form won't unload
Insert row between different item
RE: disappearing worksheets
A Rather Involved Summation Macro
stop looping and comments on VBA
Convert decimal hours to time>24hrs
manually specifing a range in the code below
calendar control - pivot table input variable
Bug in OLEDB ?
COM interop with .NET assemblies does not work (mscoree.dll)
Pause macro, add form button to sheet, continue macro when button clicked!
done!
Refer to a sheet in a cell
Formula for a date
User form controls add
Stay in TextBox
Delete desktop icon with VBA
Macro to add 1 or more days to a date
Positioning copied pictures
Subscript out of range error
Printing and saving file.
Listbox Data to Cell Comment
Macro or IF statement??? HELP!
Encrypt Or Hide Macro
Macro and Pivot Table
Date from InputBox
Insert Image in cell B13 on Protected worksheet
Re: rng.value = rng.value
How to get the available sheet name
Macro to delete 0
VBA - Adding Rows
How do I get an Excel Macro to repeat automatically?
Change the sheets (Name)
Clearing a diagonal line in a cell
Opening a workbook based on a cell value
Disabling menus etc
Selecting cell next to a value
Creating a pivot table of a pivot table
Best place to learn about macros
Building/Creating an Array
Vba add data to cell from userform
Highlighting a cell
Macro Deletion/Removal
Is this doable using Excel?
macro for matching contents in external file
CONTENTS OF TEXTBOX TO BE THE CRITERIA ON A DATABASE QUERY
Macro
Write a macro to populate a column with a formula
Is this doable using excel?
End Of File in Code
Combo box wont change selection?
Re: setting value to be based on previous cell value
Re: Help! Macro to select all sheet from AA to ZZ
VBA format cells
Bob Phillips - are you outh there today?
Excel 2002: Need help with Listview
Formula that captures criteria from 2 different columns "Help ME"
DATEVALUE and TIMEVALUE
Update cell's value without refresh screen?
Is there a formula for this?
Re: ActiveX control for chart
Combobox.clear
Removing objects without unmerging cells
Creating a Toolbar to add-in
Division on a sliding scale
Sleep, Wait and Busy cursor functionality
Macro
Subscript out of range?
Copy and paste the worksheet to New workbook..
Insert a Row
Embed a form?
Combine rows of data in a worksheet
combine data
Too much recalculation
CODE FOR CHECK BOXES, AND EXCEL AS ATTACHMENT !
help with vba and command button
Interesting challenge
Excel VBA - InputBox DEFAULT Value?
workbook opens in design mode
Modeless User Form and Worksheet Focus
Find Next Empty Row
Conditional Formatting
IF , Then
changing font color and weight in comment boxes
textbox formula outside procedure
finding a cell has a wrong reference.
Validation button using VBA
Using VBA to create cell formulas
Fill in Combo Box with range values????
What's wrong during VBA project compilatrion?
VBA Automating vlookups
return the value of cells and not the formula
How handle Hyperlinks
Passing values to new app
Mouse over events for Active X objects in excel
parsing data into worksheets
Auto-checking a checkbox based on cell contents.
Posted Code
Re: Where to start programming???
Easy one: getting the name of a picture
ODBC error to Access to DB2
Re: Creating Charts in Excel 2002 (XP)
Max Memory in a Excel Com DLL
Data type problem - ODBC Excel '97-2000 Driver
Very simple ActiveSheet.name question
Compile error
Userform question
Adding Comment and AutoSizing
Printing sheet order wrong for workbook
mouse move and exit event
Need help to write macro please
Date Formatting Bug
relative reference in a macro to define a name
Macro for selecting random lines
Protection Message
PgDn in UserForm
Variable usage in Range Command
Make achange to this please
problem running macro from schedule task
Tab Key Behavior
disregard the Outlook dialog box sending task/eMail from Excel 2003
Huh?
How to make a worksheet uneditable?
Getting WorkstationID
named ranges - changing ranges with month selected
Search Row & Column
Macro to copy daily text file
repost: Print *.tif file from excel vba
Excel 2002, VC++ problem, CreateDispatch not working
how to confine the range of movement of cursor
Help with Macro
How to enable/disable a button.
Row reference
How can I read/write file with binary format???
Help With Restricting Values in Data Entry Forms please
Userform Size
Save excel sheet.
VBA Code runs out of memory - too much copy/paste?
"for each element in group" question
formating the cell background color depends on the value
Calendar Control
IP Address
Updating the formula by program
Userform Images
Combobox with Commandbutton in Userform!
How to Treeview in VBA
set cell to today's date macro
How to set AutoFit property in Excel for merged cells
excel open file macro
Using VBA to do this?
How To: Is a Row a Group Row
Automation Events
How to keep this picture visible?
How do I include wsh or vbs code/script in an Excel macro
Empty row
How to get Name of person signed on Computer
Running a saved query
Inserting Lines And Copying Them
More than 1 workbook in a VBAProject
Why won't this work?
Move contents of entire column
Attaching drop down to macro
Reset system clock?
Use of Indirect function in Data Validation List
Re: need help with formulas/vlookup
Sorting Worksheet Tabs
Splitting up text between two fields
why is select method invalid when sharing
MailMerge using a word object
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs
New to macros...
Find and Remove Duplicates
I "DO" have a "DO"
Using formulas in VBA
sorting
Is there a better way to do this??
User Defined Function
creating a range by searching another worksheet
strange message
WRAPPING TEXT IN A TEXT BOX !
VBA: Link Chart Title to Drop Down Menu
Users in different countries error
Automation and Macro or VBA help in xl
Paste Data from the Web Into a SS & SS Runs Slow
Help! - Formatting Oddity
In need of advice?
Range Naming using cell data
Re: Macro button
Re: Macro button
Disabled macro going from Excel 2002 to Excel 2000
MANUAL & AUTOMATIC Horizontal Pagebreak Report - an example
Using TRIM function for whole worksheet
Trapping/Answering MsgBox When Workbook Opened From Access?
Re: SQL Query from Excel
Re: Problem with "For each" loop using .NET Interop and Excel
Modify Code Creating a Formula List
Re: Modify Code Creating a Formula List
Finding 5 consecutive empty rows
Re: using a macro to move a function into excel cell
Corrupting a Cell
Re: using a macro to move a function into excel cell
access cell values
access to cell values
Can I Make Macros Available on A Floating Toolbar
Nested Countif
About Digital Signatures
Count Worksheets - Late Binding