- How to simulate worksheet rename event
- Automatically update column - Autofill
- Application / Object Error 1004
- .Net and Excel 2000 Protect
- Sorting by date
- excel vba
- Creating PDFs from Excel VBA
- NumberFormat question
- Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement
- Linking check boxes
- Copying worksheets across workbooks
- Add a Spreadsheet to a VB Form
- Storing a Macro name in a Variable
- VBA Macro Help
- moving table to next page
- Re: Array(arglist)
- TextToColumns Destination:=another worksheet
- Looping
- Macro to delete blank rows
- (Follow-up to earlier sort question) Further help required
- Help !!! Pivot Change with Parametric data
- Centering the text in a message box
- Transforming Excel data to Xml
- VBA Macro Help
- How Do you Change The Color Of The CommandButton That You Just Prshed
- Looping
- Run-Time Error '91'
- CELL FORMAT
- How do I set up a template to assign a unique number?
- Moving 'Closed' Rows
- Wanted: Data Analysis Workbook
- Message prompt in VBA
- Format a Filtered range's header?
- worksheet_change event fires multiple times
- Macro to copy cells one row up then move down 4 rows & repeat
- Conditional Filtering with cell format
- Protect Cell Formatting
- Date Formatting in Code
- Add-In
- A Question about Listboxes
- Wanted: Data Analysis Workbook
- Compare Cells on Sheet to ListBox Selection
- Disable/ Enable Macro
- Excel Image.
- worksheet_change event fires multiple times
- Create macro to download access 2000 table to excel 2000 spreadsheet
- Validation
- Microsoft Jet workspace
- xla add in issue
- Excel auto-start macro
- Using a macro to save a file.
- Nedd Help with an input box
- clipboard pop up
- Pivot table Programming
- Retrieving Dropdown/Option Button Values
- Parsing a string to retrieve numerals
- changing image control's picture path
- Parsing a String to get Numbers
- Clear contents if x is not in the row
- Percentile Value
- Copy referral $ sign to other cells.
- Copy referral $ sign to other cells
- display long number as text
- Sending Personal.xls Files To Multiple Users
- Filename with date and time
- Macro to replace * with /
- using a input box
- Code To find and run an EXE file out side of the Excel
- Histogram / Count Programming Problem
- Retrieving Dropdown/Option Button Values
- RE: Run-Time Error 1004
- code for printing
- Im so close. Need variable range for the pivot table
- Forcing an input in a pop up box
- Need Help with executing a function based on time.
- Hide colums based on dropdown list
- Custom Windows menu
- Shading cells based on Other Sheet Value?
- Renaming macros...
- remove assemblies on save?
- Removing records from entries that begin with *.
- Run Time Errors
- cell values
- computer name find
- Deleting XLA codes ...
- XLA auto_open
- Filter and copy
- Testing for existence of a worksheet in the active workbook
- do .... loop
- Check for DLL Reigistration
- Click event to run only once
- Colour Cells depending on time
- Can anyone help me figure this out?
- Change all text in a column to uppercase
- Checkbox List in VBA?
- activecell
- do .... loop
- Software of scripting to grab data from MS word file and fill in Excel fields?
- Dialog Boxes for Excel Program
- Inter-process handling
- Sending Personal.xls Files To Multiple Users
- Creating Trainees with macros
- Loop through selected cells
- Open as template only
- Open as template only
- Worksheet_Change method not working in Excel 97
- Make a Cell Act like a Button
- do .... loop
- Automatically update column - Autofill
- Colour Cells depending on time
- How to record a sheet change showing row column sheet name and date?
- "Stop" not working
- Excel formula: select value in column if condition in 2nd col met
- Check Drive Space
- Need Urgent Help Please
- How to record a sheet change showing row column sheet name and date?
- macro not ending
- How to record a sheet change showing row column sheet name and date?
- Enter Symbol showing on worksheet from text box entry
- Copy Data
- How to set series data in VBA
- Copy Code
- checking variances in cells
- Can I run a macro/program when Excel saves worksheet?
- PivotTable After Refresh Event???
- match and/or index
- Sql Table Join?
- How to record a sheet change showing row column sheet name and date?
- SQL Keyword
- Cell outlines missing
- Enter Symbol showing on worksheet from text box entry
- Textbox calculation
- Text Box Calculation
- Current Row number
- Keeping a workbook hidden when opened via VBA???
- VBA Automatically Changes Cell Format?
- Excel Visual Basic Project Explorer
- Default formatting settings
- User defined functions
- my message in Status bar
- date format in excel
- CellColorIndex - not working
- CellColorIndex - not working.
- IF statements
- unprotect VBAproject, change library refs?
- Saving work sheet
- macro loop
- emailing attaching active workbook to it to myself
- Change event
- CellColorIndex - not working.
- "IF" syntax
- Keeping a workbook hidden when opened via VBA???
- Calculating the difference between hours
- Duplicates
- Creating Directories
- Protect the sheet
- xlodbc returning no rows & no errors
- Reference Library - Missing Library in a lower version.
- How to show/hide sections of a userform?
- Unfilled data worksheet
- Resources
- Signaling the presence of a password
- preventing / converting 'illegal' characters in file-save text string
- Refer to Range Name in Page Header
- how to find last row/col index within a selected range
- worksheet_change event fires multiple times
- Protect the sheet
- Resources
- Macro selecting rows.
- Sheet selection
- Notification from Excel VBA
- Determine elapsed time between two dates
- error handler in macro?
- Custom Number Format for Feet and Inches?
- Macro to change list box input range based on selection made in another cell
- Feet and Inches
- Calculating the difference between hours
- # of Spaces macro
- Another avoid the loop trick request - on fast fill (Maybe an Alan trick)
- How to make a more interactive spreadsheet?
- Allow certain users to edit certain rows?
- Paste txt to word
- Duplicating a Workbook
- Calculating the difference between hours
- Lookup List
- Maintaining Macro Toolbar Button Properties
- Run-time error ‘91’:
- Hide shapes (buttons) before printing
- return all worksheet tab names and chart sheet tab names in report - an example
- Preserving Row Height with Paste Special
- New Sheet
- Using add-in through intranet
- VBA Excel
- How do I make a value required in a cell in Excel? ex: Name, Last.
- PrintArea
- vba search
- Evaluating Empty Cells
- does workbook contain worksheet
- long time to create toolbar in excel 2003
- Declare Variable
- Variable results to new workbook
- Allow certain users to edit certain rows?
- Get Module line # for error trapping
- Can Anyone Solve This One, Please, From Liz
- PrintArea
- Vba printout
- Menu attached to a form?
- Declare Variable
- how do i use R[]C[] notation in Excel visual basic
- SHARING MACROS VIA ADD-IN (.xla) FILE
- Control Button is still selected after macro runs
- What is best method of filling in fields on an MS Word Document?
- Excel visual basic
- Evaluating Empty Cells
- Problem creating a macro
- VB6 Excel 97 code no longer works if Win2K SP3/4 applied.
- Runtime error 380: Could not set the List property. invalid property value of listbox
- PasteSpecial
- Is there a function to convert a string representing an integer i.
- Hidind rows conditionally
- Protection
- Allow certain users to edit certain rows?
- RP or TO - Add all files EXCEPT active file?
- Mail to multiple receipients
- CTRL+SHIFT+END
- filtering resp. today()
- Validation problem
- Change it from 7,6,5,4,3,2,1 to 1,2,3,4,5,6,7
- web spreadsheet
- Form & combo box question
- Need macro to autofit height for merged cells
- Visual Basic File selection
- protection annoying - how to fix it
- How could I get the client's browser to refresh an HTML spreadshee
- Access Mask equivalent?
- Range question
- Range question
- Multiple print areas, one worksheet -need to print to PDF!
- Click event to run only once
- Macro: With Stop it works. Without Stop it doesn't.
- sort cells with spaces to the top
- linking spreadsheet nightmare
- 8th Order Polynomial Trend - Is there an easy way?
- VBA and Goldmine (DBase)
- Macro Design Help
- Autofilter
- Sending Personal.xls Files To Multiple Users
- Public variable defintion (newbie)
- Trouble with worksheet_calculate
- Read/write a Serial Port
- SHARING MACROS VIA ADD-IN (.xla) FILE
- SUMPRODUCT for 3D values
- intermittent problem with clearing textboxes on forms
- Saving file to compressed folder
- Simple Case Of Protection
- Macro to open all linked workbooks
- Extract data
- VBA IN AUTOFILTER
- Excel formula - overwritten files and data
- Data From Two tables using SQL
- Multiple Userforms at once
- Test for char in string & separating if present
- Access worksheet by name
- Reference not responding
- Pivot table - 256 character limitation?
- username & password check
- Access worksheet by name
- Better help in VBA for "NumberFormat Property"
- ADO - accessing oracle
- Pasting into a row specified by a value in a cell
- dfgdfgfdg
- How to handle Cells Value #N/A
- RE: How to improve visuality?
- test
- Post from Excel?
- dfgdfgfdg
- Define Object Variable
- Centering the text in a message box
- Pasting into a row specified by a value in a cell
- calculating undefined ranges using vba
- How creating a color listbox in a cell?
- Sage Excel Link Error
- Print preview in a user form
- TXT file to Excel
- Selecting Workbooks
- linking spreadsheet nightmare
- Colour Cells depending on time
- Testing If password is being cracked?
- Using AND to eliminate IF statements
- Cell value controlled by button
- Declare Variable
- AutoFilter
- ToggleButtons are strange
- Automatic change for time constraint
- Help with Calculation
- Automatically update column - Autofill
- sorting code problems
- Public variable defintion (newbie)
- Help
- Commenting in Code
- User Defined Function - Title
- Introduction in file Send to
- End Double Sub
- Critbinom
- Require extra funtionality - existing code included
- VB runtime error codes
- Ranking issue
- Object Numbering
- How to automatically populate using Macro
- How do I autopopulate data in excel?
- Is workbook / sheet protected
- Remove digital signature with VBA
- how can I format a .csv file from external data?
- Pivot Reports (by date)
- Get rid of some message about macros.
- Clearing user forms
- reloading a userform query
- Instructions within VBA Functions
- Declare Variable
- how to export a function from a vb6 activex dll
- Declare Variable
- replace a string in the worksheet
- Instructions within VBA Functions
- new sheet ops in macro
- Trigger a sub when cell changes?
- Environ Function
- Formula as User Defined Function
- Instructions within VBA Functions
- SheetList - Help with skipping sheets
- Instructions within VBA Functions
- Annoying Pop up box in function
- Multiple users using a single userform
- Calculating the difference between hours
- Declare Variable
- Previous Worksheet
- Annoying Pop up box in function
- Allow certain users to edit certain rows?
- MyHelp - VBProject.Helpfile
- Annoying Pop up box in function
- Trusted Security Tab
- File Already Open Error When Executing A Macro
- ActiveWorkbook.EnvelopeVisible = True
- Re: Trusted Security Tab
- Data access using ODBC datasources
- Resources
- Deleting a row by a column value
- Emptying cells containing a single blank
- File Already Open Error When Executing A Macro
- macro help
- Is there a macro function to find out if a cell contains a functi.
- Formatting problem Excel
- Resources
- Calculating the difference between hours
- Annoying Pop up box in function
- Instructions within VBA Functions
- Instructions within VBA Functions
- Combobox Question
- Deleting sheet
- Annoying Pop up box in function
- Selecting and formatting cells
- Is it possible
- Annoying Pop up box in function
- First textbox in form not accepting input properly
- Instructions within VBA Functions
- Exporting data from Excel into MS_Project fields
- Importing Outlook Items into Spread Sheet Eats RAM!
- add sheet if statement
- side-by-side worksheets revisited
- Closing a workbook programmatically
- CheckBox question
- Control Notepad from Excel
- Do same thing to each workbook found in a folder
- password protection
- print range name over multiple pages
- SHARING MACROS VIA ADD-IN (.xla) FILE
- Can VBA accept input from a message box?
- Excel causing exception error upon opening the document
- Call a program from Save As dialog
- Probably the most easy question here...
- data subtotals is not working correctly in Excel 2003
- select all cells with comments in a specified range - two examples
- Save/ Send as webpage ?
- Run-Time error 1004????
- Colour Cells depending on time
- Counting literals in cells
- Automatic change for time constraint
- calling Word from an .xlm macro: how to?
- checking variances in cells
- How can I Improve query speed?
- Passing listbox object as parameter
- UserForm_Activate not found
- Multi-select listbox help!
- How to open an excel file from vbe in hex format ?
- Embedded files in Excel
- help needed
- Excel and VB
- MsgBox Spacing of Characters
- How is time represented? How do i make an equation representing 5 minutes?
- macro to transpose cells in Column B based on unique values in Column A
- help for teacher!
- Sendkeys and active windows
- Listbox that dont refresh automatically
- create multi-field, with layout, user questionnaire to save reply.
- Click event to run only once
- MsgBox Spacing of Characters
- want formula
- extract cell reference in one formula and add it to another formul
- Email from Excel....autosignature?
- question about Auto_Close and WorkbookBeforeClose
- Automatic change for time constraint
- How Do You Get ISNUMBER() To Work?
- End Double Sub
- How Many Simultaneous Users Can Be Safely Handled?
- If-statement in Macro
- Excel.Union returning two Areas
- Programmatically increase the row # in a formula
- activate excel tooltip
- If-statement in Macro
- MsgBox Spacing of Characters
- Deleting An Access Table
- Select Range - using Offset ( 40 ,0 ) - not working
- RTD Problems
- Writing to a text file
- Call Sub Procedure object_Exit(ByVal Cancel As MSForms.ReturnBoole
- End Double Sub
- End Double Sub
- Creating a Dashboard that will change according to KPIs
- RefEdit in VB6
- why are the options on my forms menu greyed out?
- Ctril + G in 2003
- Can I save an excel file as a particular cells value?
- Automatic change for time constraint
- Creating a Dashboard that will change according to KPIs
- Date Logic Locking up and not calculating
- How to create a .XLS file instead of a .CSV file
- Automatic change for time constraint
- Re: Automatic change for time constraint
- End Double Sub
- export chart as jpg
- Date Logic Locking up and not calculating
- Disable Splash Screen
- Automatic change for time constraint
- Userforms???
- Closing a worksheet
- export chart as jpg
- Combo Boxes
- HELP
- Screen shots capture
- multi column list boxes
- How to increase rows beyond 65535
- characters that do not print
- Get ActiveSheet name in VB
- How to refer to a listbox
- minimum value in range
- Update of cells does not work from VB6
- Excel windows media player links
- Check if within Function Wizard
- Modify - look at files within subfolders
- find replace function with a database
- Using VB to change Combo box selection
- find replace function with a database
- Data from userform to worksheet
- Display Size
- Ranking issue
- Print Macro
- VBA Invoice Open New Window
- Excel 2003 object model
- Is .xls password protected.
- ADO Function
- Passing an array or recordset to a stored procedure
- Checkbox and button snag
- Frozen Panes
- Help! Please!
- VBA in other countries
- find replace function with a database
- A question about Userforms and tabbing
- after sort macro, excel window minimizes
- Variant datatype in Excel 2003
- Dialog Box/Form Help!
- userform always on top?
- Help needed with basic programming
- Link spreadsheets by clicking on a field
- Get Data from Selected Cells
- Removing Excel password.
- If Then Statement
- Help needed with basic MACRO
- Help needed with basic MACRO
- find replace function with a database
- Index(Match...
- Help needed with basic MACRO
- Compare all following columns when value is same
- How do I set a macro to run when I click a Command Button in Exce.
- Checkbox and button snag
- A question about Userforms and tabbing
- Automation between Access and Excel
- Dialog Box/Form Help!
- How to use macro to open an specific file
- Setting up a personal menu using VBA
- Modify Web Query using macros?
- ComboBox and 2 Dim array
- Using VB to change Combo box selection
- Trying to identify what is not there
- Setting the Options of the Find method
- macros
- Format function question
- Addin, Funtion
- creating array using name references
- User forms that are generated at runtime
- Macro Help
- Please help with programming
- Linking tables
- Finding difference between two columns
- Sort/Filter by date
- Disabling Ctrl-PgUp and Ctrl-PgDn
- Workbook_Open question
- Formatting charts, problem with deselection.
- Ensuring UserForm Textbox Entry is numeric
- Generate all possible combinations from three data sets?
- Alt + Enter hotkey - what does this do?
- advanced macro for find replace
- Macro or VB Code to Summarize Info.from 4 workbooks
- VB programing
- Simple Selection Macro
- FormulaArray and Ranges Question
- Userform Editing/Access
- Data from userform to worksheet
- HOW-TO: Determine if a cell contains a number vs. formula vs. reference
- compatibilidad de excel con foxpro
- Remote shut down of Excel
- Stopping an excel macro while it is running.
- Re: FormulaLocal / FormulaR1C1Local not working
- Row Count in Clipboard
- how to protect VB script
- Return OLEObjects values or names - two examples
- Colour Cells depending on time
- How to call a "xla" object itself?
- How to create a "xla" add-ins and active it.
- Data from userform to worksheet
- require password each time a macro is executed
- don't understand whats wrong with this userform
- Help with a User Form problem please
- Folder List
- combine code to get data in one sheet
- Msgbox w/ multi-lines
- ComboBox and 2 Dim array
- MsgBox Replacement w/ an UserForm
- Calculating the difference between hours
- Delete Rows with particular dates
- MsgBox Replacement w/ an UserForm
- FormulaArray and Ranges Question
- Line item calculation
- Calculating the difference between hours
- MsgBox Replacement w/ an UserForm
- Resources
- Calculating the difference between hours
- Script to add hyperlink to Excel cell containing text
- Finding MIN, MAX, and average
- RE: Auto tab
- Finding MIN, MAX, and average
- get linenumber when string found in VBE codemodule
- If-Then-Else resulting in DIV/0 error
- Dimesnion a variable on the fly
- Using IF to locate specific text string value
- number too long
- If-Then-Else resulting in DIV/0 error
- Problems with select case
- If-Then-Else resulting in DIV/0 error
- If-Then-Else resulting in DIV/0 error
- If-Then-Else resulting in DIV/0 error
- If-Then-Else resulting in DIV/0 error
- find highest number display the complete row
- Compare Date in Cell VS a Variable Date to Hide Row
- User Form focus
- help please
- Help with Calculation
- MsgBox Replacement w/ an UserForm
- comparing dates
- Researching single pairof data problem...
- Help with ComboBox Please
- Re: Using ASP and SQL for Workgroup Collaboration
- Calling VB from Excel
- Chart formatting - CommandButton
- Assignment problem
- Calculating the difference between hours
- Quick Question???
- MsgBox Replacement w/ an UserForm
- Re: Using ASP and SQL for Workgroup Collaboration
- MsgBox Replacement w/ an UserForm
- Excel VBA - Search And Replace Cell data
- Re: Recording data from refreshing, imported sheets
- Help is needed for modifying this code.
- Compatibility with Excel 97 Questions
- EUAC EXCEL FORMULA
- userform always on top?
- need help opening text file
- Cell format and User form question
- userform with mailto
- Dynamic WorkBook Linking
- Can this formula be used in VBA
- how to create "template columns"
- How to use Names in VBA
- help please
- Adding name to a range of cells
- Extracting Hyperlinks
- Copy/close web pages
- MSComm32
- Macro Subtotals
- Copying text file into worksheet
- autoexecute macros on open or new
- how to detect when cell contents has changed
- Problem of "copying worksheets from multiple workbook into a single worksheet"
- Hide a cell using Windows Script
- SIMPLE UserForm w/ 2 OPTION BUTTONS
- Help with Macro Recorder Please
- How to keep a picture in Excel 97 page footer/header?
- Msgbox w/ multi-lines
- Menu Editor
- Spreadsheet to .txt.
- Different length moving averages
- Different length moving averages
- Save and Close Pop Up Box...After Save and Close In VBA
- linking code across different workbooks
- Option button
- VBA in other countries
- export chart as jpg
- worksheet function or programming_urgent
- DDE Initiate does not work
- get day from date
- How to allocate movement if expected last record is missing
- User Form Frame size
- Selecting text in cells & half of the Selected Text to be underLine
- Excel VBA basics
- row selection
- Editing a protected sheet
- Automation error???
- Pop Up Messages when saving a file
- Application.worksheetfunction
- Pop Up Messages when saving a file
- IF formula headache
- Combo Box Standard code
- InputBox - cancel button
- Delete is Pressed then Stop
- Turn off Excel's 'want to update info?' prompts
- delete name range
- LoginID
- VBA Conditional formatting
- Calculating the difference between hours
- Help with Macro Recorder Please
- Reads entire *.txt file into string opposed to a desired line by line input.
- hide/unhide cell when clicking a cmdbutton
- custom charts not accessable to all users.
- Excel 2000 AutoFilter and Worksheet protection
- Create an ADO connection to current sheet
- Quick question
- VBA Conditional formatting
- search range, if exist, copy cell
- Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency
- Formatting Multiple Worksheets
- Sheet protection
- renaming
- Naming Variables
- Problem with Find filling a listbox vba
- File names
- Copy a worksheet without 'opening' workbook
- Range.Validation Questions
- How to show index in a chart
- Counting Cells that meet criteria across entire workbook
- Existence, Search, Test
- Increasing cell date by a month
- Disable Close "X" button on User Forms
- select multiple cells
- Disable Close "X" button on User Forms
- Problem with "Range"
- SIMPLE UserForm w/ 2 OPTION BUTTONS
- Searching concatinated fields
- How do I paste from clipboard to range using Excel VBA
- Date/Time Picker
- BeforePrint event
- Quotes in VBA Code
- Footer : Last saved date
- updating spreadsheet from textbox
- linking spreadsheet nightmare
- Label - Caption not changing
- Writing Out Numbers as Text
- How do I make a VBA procedure available to all workbooks?
- SIMPLE UserForm w/ 2 OPTION BUTTONS
- Use a simple Drop Down List or User Form
- nagivating rows and columns
- Label - Caption not changing
- help please
- Replacing Excel Add-In
- Nested Ifs
- Calling Macro by different TextBoxes
- How do you Change Column heading names
- Calling Macro by different TextBoxes
- Esc key to exit form
- Auto open 8 workbooks in different folders, then save on close...
- Adding checkbox on a row when data is entered in first column of that row
- Opening files
- Accessing VBA subroutines in another workbook
- build array of columns
- Increment a Variable Defined Date by 1 day
- Click event to run only once
- Combo box to filter
- Excel Help File Hyperlinks not working
- Global vs Local variables
- Checkboxes and DropDown menus
- Esc key to exit form
- Delete ComboBoxes using a macro?
- why can't I additem to multi-column this way..
- Re: preventing / converting 'illegal' characters in file-save text string
- <Method 'Range' of object '_Global' failed> error
- Toolbar 'Hiccup' problem
- Pivot table data source
- Distribute calendar.ocx within an excel file ?
- Searching a filename from multiple workbooks or drives
- Records in a form?
- Copy Number Formats
- VBA code striped off?
- Records in a form?
- Inserting a SUM Function
- Calculating the difference between hours
- dynamic name range in VBA
- Calling Macro by different TextBoxes
- Is it possible to run DOS commands in Excel?
- do you know how to take out the 011 from this number:011548926 in.
- formatting text/number in a command
- How to catch Drag-and-drop in Excel 97?
- copy random rows
- Searching Data using Macro
- Security - Delete File
- Searching using part of a word rather than whole word in vba
- Selection is set to Nothing on second run of a AddIn function
- Accouting & Database
- sensitive button
- Pop Up Messages when saving a file
- Searching using part of a word rather than whole word in vba
- Sort - fill in - unSort
- autscrolling textbox on modeless userform
- sensitive button
- Publishing an interactive spreadsheet
- Data Filtering 'Show All' macro
- VBA Compatibility Between Excel 2000 and 2002
- Someone must know
- Suppress warnings when saving text file?
- How doable Using Excel?
- Find and Display / Modify code
- Multi-user dilemma.
- Draw Picture using VBA in Excel
- How do i download excell to my pc? please help