Excel Programming [Archive] - Page 133

Show Data Form
Macro for Parameter Query
Worksheet Change
AutoShape name assigned to macro
Using "Select-Into" text file from XL (Attn: Jamie Collins, others
Email and if statements
visual basic pasting formulae
if cell is hidden
help with looping range and extracting value
ControlSource in a userform textbox
Cannot Remove Missing References
Using Esc Botton while filling in userform
Printing in Draft mode
Calculation does not appear in userform
how to sum numeric values of column (variable length) in 1st available blank cell
Bossing the Text Import Wizard about
ADO - recordset - closed excel workbook
Sheet number variable
ADO - recordset - closed excel workbook - know sheet name and cell name but no named ranges defined
Ranges and Arrays - Passing values
Print the same page from many different named files
String manipulation!!
Sheet number variable
Macro for Parameter Query
Re: Delete command button
Excel Automation - loading text files
Opening a file from a set folder
Can not change the numberformat
protect workbook and allow hide/show worksheet
I have saved over a file by mistake with a different file
Edit cell contents via userform listbox
Calculating the difference between hours
unable to have workbook protect
Date Problems in Excel
Excel Add In - Limited Use?
protection workbook
Cell Search
how to protect from insert, delete, resequence worksheet in workbook
Pivot table protection
how to schedule to run excel macros report
deletling messages from newsgroups
Compare A to B to get C ??
accessing a workbook cell in a different directory
some doubts....
Passing variant arrays to C/C++ dll's
Hlookup, but to next highest value
Calculation does not appear in userform
VBA project does not close when workbook is closed
VBA project does not close when workbook is closed
VBA project does not close when workbook is closed
Saving as a specifc file name in increments
Generic Name for ActiveRange in VLookup
VBA Code to add date
Pivot caches?
VBA Code to add date
Email and if statements
Place a check box at a particular cell
cell security
Array Sheets Copy to new Workbooks
Still stuck
Crete an An Account with regular withdrawls with a declining bala.
security
round to ,5
Help Please
Moving groups of cells with mouse
Moving groups of cells with mouse
VBA Code to add date
Copying Macro help needed
formula or macro
print scaling
Help Please
ByRef strangeness
simple loop macro
Moving groups of cells with mouse
simple loop macro
simple loop macro
creat the records based on the values in another sheet
Removing commas
Auto_open & Application.ontime in shared files
simple loop macro
Trying to adapt progress meter
MACRO question
Data from multiple variable length columns to one column
Search Code
Pivot table
add-in installation Inno setup file
RefEdit causing crashes
Calculating the difference between hours
Calculating the difference between hours
Valdiation
dynamic rows
Workbook open event not firing (both 2000 and XP)
"Immediate Window" displays strange code!
Adding a 3rd IF statement ??
Help Please
Help Please
closing boxes
sumproduct or countif
Adding a 3rd IF statement ??
how to combine items in 3 columns and produce all combinations usi
Message Box position
Macro causes "Do you want to replace the contents of the destination cells"
object variable or with block variable not set
Excel->Access OLE Error
Unprotect workbook
UserForm Toolbox displaying
debug message pops up when I select a range of cells and delete
loop to insert rows
loop to insert rows
Close workbook with "Cancel=TRUE" in the BeforeClose()"
1. Selecting multiple items from drop listbox
object variable or with block variable not set
Macro to edit existing formulas
Re: Help with commission form
number formatin XL 2000: mixing alph.chars.& numbers
Boolean formula for Conditional Formatting
String problem.
Copying to another worksheet
dragging userform
Paste value of Find
Sheet Protection and Book Recommendation
chart graphing
How to connect to iSeries and run a query using VBA
Disable auto xlmsgbox, replace w/own
User Form Help
Treeview save Data reload, Speichern der Daten Excel VBA
can't find a correct formula
Rounding Percentage
search rows
sheet event does not recognise Tartget
Block saving using dates
Turn Off Macros With Workbook Open
remove add-in entry via registry
Hiding Macros?
Excel Add In - Limited Use?
Colour of Precedent arrows
Changing value of chart axes based on the minimum value of the plotted series
Cell Position
how to paste to last row in another sheet
how to know which row to append for the last row
date out of control
sum a salary column using macro
FindNext
Help please - how to run Solver in a protected sheet?
Web pages that run an excel spreadsheet
Re: opening a file that will have wildcards in VBA
Re: VBA excel + Forms : Vlookup on database by form / VBA excel +formulaire : rechercheV sur base de données viaformulaire
Re: copy down
Web Query Run-time Error
vba on vba
pivottable page fields
Re: I need some Advise
Limiting view area to user
Change Icon
Re: If then statement with two true conditions
Re: data validation question
Re: web query and changing URL's
Re: web query and changing URL's
Limiting view area to user
Re: Scroll the window to the top - frozen rows
Help with commission form
web queries & URL's that change
Devide/0 error
web query & changing URL's
Web Query & changing URL's
Formula too BIG Excel 97
Web Queries & changing URLs
Active Cell
Document a .xla file
Web Query and Dynamic web address
Select Case from Text Box Input
Bottlenecks in an Excel VBA application
how to excel with more features?
Scroll the window to the top - frozen rows
Intercepting a Tab on Entry
permission denied while drying to create a excel instance
spesific fonts for headers&footer is Excel
Sorting problem
Sorting problem
Using "GetString"
Comparing two lists
Solving for a variable multiple times
copying page with VBA
Comparing two lists
macro - hiding rows given a cells content
Applying styles in VBA, then pasting into Excel
Conditional Formatting Columns
Total question (macro?)
Comparing two lists
Erzeugen einer Excelinstanze verursacht Zugriffsverweigerung
using VBA to rename active sheet
Comparing two lists
Create toolbar take long time
Excel 2002 VBA - my toolbox controls have dissappeared
Appending to workbook and worksheet
Sorting problem
Goal Seek
Conditional Formatting Columns
Extracting variable sized strings from binary file
Trouble call VB ActiveX dll from Excel
Running macros
Macro to Record date workbook is first opened
Conditional Formatting Columns
Writing to a file from excel
count the occurence of number in a column
combo Box programming
Numberformat in ADDIN module doesn't work.
selection by values
Excel 2000 sp3 problem with vba and Solver AddIn
IsMissing()
Program to change the Excel cell to a different color.
Programmatically Creating Worksheet Event
How to apply changes to many WBs in one go?
On Error Goto doesn't goto
Auto Update
On Error Goto doesn't goto
Moving data from Excel to Access
macro to delete rows
macro to delete rows
Using "GetString" with ADO
Comments to help Users
graphing in excel
macro for printing pivot charts
call sub
Excel Add In - Limited Use?
Macro to Open all workbooks in a folder and change default font
Time Clock
how to store a value generated in a sp sheet
Macro dependent on hidden sheet?
Edit Mode
Using ADO CurrentProject in Excel
Filtering results
Custom face on a button without clipboard?
Custom button face without clipboard?
multiple combinations
Workbook Open Event does not fire
Inputting numbers only in Text Box
Automatically execute a macro
Copying a sheet to a certain position
Edit Mode
Date format problem following cut/paste from Access
Visual Basic Getting confused with Dates
Custom face on a button without using clipboard?
Excel Add In - Limited Use?
Using Excel to extract data from SAP
handling the print to file prompt
How to add UFD arguments description?
How to hide excel?
Print_Area link problem
userdefined trendline
Deleting shapes
Function calls a Sub to change the cell font color
how to count/sum by function/macro to get the number of record to do copy/paste in macro
XP activesheet.paste error on VMware servers
Strange Title Columns Print Issue
Copying rows with spesified data on one or more columns from sheet/file to another?
Toggle CommandBarControls msoButtonDown/msoButtonUp
run macro text missing
How to save a vary filename by Macro in Excel?
Printing question (VBA)
multiple outputs
hide a row
How to hide excel?
I dont know if this can be done
I dont know if this can be done
Protect Excel sheets with Password Using VBA
Cannot dropitem from multiselect listbox
some problems calling components :(
assign value to cell in another worksheet
Combining 2 Ranges in a Single WITH Statement
Working with Comment objects in VBA
For Each with Select Case
Conditional Statement?
For Each with Select Case
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
VLOOKUP
Next function?
list of proprties and methods
Using for next with two counters
Excel table function
Retaining the ONE most current dupe...
IsMissing()
Huge File size after import
summing a range in a closed file
Invoke â€œQuery Wizardâ€ programmatically from automation or VSTO
Invoke â€œQuery Wizardâ€ programmatically from automation or VSTO
Hide calculations during computation
Huge File size after import
Make a cell mandatory before sending
alphabetizing and grouping
Alphabetizing and Grouping
E-mail Macro
For Each with Select Case
Creating Drop-down menus in Excel
E-mail Macro
CopyFromRecordset with large amount of data
copy paste with min data transfer
Cycling through variables.
help with textbox change event
Moving from one Excel File to Another
Excel VBA Loop & Variable Reference
How do I select on a SQL Datetime field in Excel Query?
is excel by itself enough to do scripting?
Filtering results
Application.Quit
Blank rows in a filtered list
VBA - Combine Workbooks
So simple I can't find the answer!
Excel window will not exit.
change faceid
check protection
Filtering results
Forcing case
How to fit a "ln" function
Check if DLL is registered
Formula Range
Collapsing a table
lookups
inputting (x) triggers input of 1 through (x)
This may sound stupid.....
Programmer for hire needed
addin problems
microsoft excell
Having a problem getting Excel to work from my .Net VB Program
Filtering results
How to print last page of sheet?
Can not change the numberformat
How do I insert a row and keep all the formulas in the cells?
Shortcut menu help
Converting text data type to numeric
VBA Object Browser icons key
Sum Based on Cell location in Column
Add autorecover to excel 2000
Desktop Shorcuts
Creating Directories
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
how to list all validation cells on a sheet
Add Worksheets
Proper Syntax Sought For NewBie Excel Programmer
UDF was not being calculated for all cells
Current path to Qualified Path
Sending an email
Buttons not to be printed
Contiguous Column Selection using variables
Editing Module thru VBA
Determine version of .xls file from VB6
Horizontal scrollbar in ListBox
Compile error when running a vba script.
Runtime error 1004 - when I increase the amount of data
Excel Addins - Index or key
Calcultae % with empty cells
Copy layout to all worksheets
formatting text/number in a command
Macros - Relative cells in Excel
Excel Addins - Index or key
Excel Addins - Index or key
#Name for user function
Please help - expected record status "missing"
Worksheet views
Prevent selecting locked cells
formula for automatic numbering the records
Excel Addins - Index or key
Counting Unique Records
pivot table
Help with run-time error, please...
Error only without references
formatting problem
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
My addin function wont run twice.
Any Idea on how to modify this code relating to query???
Help - Download Stock quotes from Yahoo! (long history)
Creating excel files using VBA
Newbie question: clear contents in first column of copy-pasted row(s)
change color and protect rows
some problems calling components :(
Powerpoint -> Excel conversion
Flag Earliest Dup
Kind of like offset.....
Pause a Macro?
Hide calculations during computation
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
Change the colour of a bunch of cells, based on one cell.
How to delete rows with repeating values and leaving only one with highest value on the next column?
Lookup macro?
path
VB UserForm to MS Access
VBA or Macro to Update Column
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
Function to check to see if cell has hard coded data in it
Istext function
Run-time error 1004 and SR-1
Handle Compile Errors
Auto_Open - Prompt to Continue?
Form Doesn't Disappear
Create Subtotal Macro
Use full page
Extract full path given filename
Newbie Q: OpenRecordset from Excel
Problem with writing CString Date to cell
Could really use some help with this macro.
Help with Time Calculations
To count an alphabet in a cell
Saving a worksheet with links
avoid access of hidden sheets
Application exception occurred:
Stumpt !!!
Averaging last 8 weeks
Cell doesn't do calculation until you force it.
Excel Data Validation
Compare two worksheets using VBA in Microsoft Excel
Logic test
Returning values from a multiple chart series
lock up rows w/dates diff than current year
linking ActiveX Controls to perform function on another control
Re: Copy continual, refreshing records to a new sheet
Bigmatrix Addin
Saving a worksheet with links
coping rows using a loop... please advise
Compare two worksheets using VBA in Microsoft Excel
How to do this?
Importing Text file into Excel 2003
Export data from Sybase into Excel 2003
VBA Code to save to 2 locations
Break out data into tabs
coping rows using a loop... please advise
Moidule Line # continued
Target Frame
Easy VBA Syntax Question
application.volatile activation
Disable Workbook_Open() Macro
Change Cell-Background color into Text
Easy VBA Syntax Question
Blank rows in a filtered list
Excel file with macro not visible
Identify duplicate values
Fill Series with Step
Sharing macros - extreme newbie question I know.
How do you get a pivot table to do server-side processing?
coping rows using a loop... please advise
Need a Macro that will sum Values in a Column that are red
error 429: ActiveX component can't create object
Sharing macros - extreme newbie question I know.
Functions don't work anymore!
rename macro
deleting file(s) by their file extension
Excel Interop > ActiveX>SEcurity exception
find out if cell is hidden in if statement
check if cell is hidden
Macro Removal
Selection Too Large
Worksheet with Macro
Macro Removal
Macros/VBA to fill time card
find from Excel VBA a text file last row
coping rows using a loop... please advise
chdir not accepting string for path
Keyboard Shortcuts
Protecting part of a Spinner
Could really use some help with this macro.
Macro to activate VB Code
Printing Multiply Workbooks from one Excel Workbook
Summing rounds answer to
Convergence
Chart - conditional formatting
computational convergence
VBA - Run Macros Remotely?
Shortcut Key
Finding MIN, MAX, and average
Alternative to ...For Input As #1
import date field from access into excel
Excel 2003 Object model for Excel 2000
User input as a range
Creating Directories
Could really use some help with this macro.
import date field from access into excel
Compare & Delete in Excel
Change Cell-Background color into Text
MS Outlook Item.Send - How to remove the popup message?
VBA Code for Logit regression
VBA Coding for Logit Regression.
Macro to group outline
Slow code operation when refering to different sheets
How to protect several columns and allow refresh query
VBA coding of a Logit regression
Small DB in Excel
VBA Code to save to 2 locations
Macro to control screen saver
Excel 97 to Excel 2002 :problems!!
Use Windows Network logon as password
Problem with displaying characters in excel sheet
Break up a text file.
Help with workbook path
Replace dot with commas
Point Scoring Using Substituted Numbers
flagging dates with conditional formatting
Runtime Error
Cell Links for Option Buttons
Filling Down Automatically ?
Linked WorkBook ... TabSheet Sort?
Image control
xlChartType
xlChartType
how to union two array with same structure
Find last cell with data
Why does my AddIn do OnConnection() twice?
Range ID not saved
Calculating the difference between hours
Changing a formula using a variable...
Turn off Excel's 'want to update info?' prompts
Accouting & Database
right click menu
Strange Formula Request
Entry of data in formula bar ignores cell percentage formatting
DTPicker not working in Exel 2000?
How to force userform to display everything?
can you insert an object into a cell
Locking Protection on a Spinner
compare and merge 2 sheets if columns same
What macro is executing?
Get bytes from file
Selection based result formula
Combo box to filter
Excel active sheet's Textbox size limit
Application-defined or object-defined error
textbox validation
Cell bordering
Web Interface Brain Buster Problem (for me at least :)
Returning the range name in VBA
In Excel 2000 - is there any way to set up a cell to repeatedly a.
VBA Formula Question
Date Function in VBA???
A beginner needs help with Excel and VB
Wie kann ich einer Zelle eine Hintergrundfarbe zuweisen lassen, w.
Excel 2003 should have the auto save add-inthat was available prev
copy range of cells using VB
Excel macro running out of memory.
inputbox vs. userform/combobox vs. Windows file handlers ???
Checkboxes in Shared Workbook
Forms that open from forms
Problem Organizing Macros under XP UPDATE
SumByCellColor
Problem Organizing Macros under XP
Compare & Delete in Excel
Cycling through form fields
Getting Access Error Messages when running Access through Excel
Left string in VBA
Complicated macro needed (please)
Multiple "With" commands - Please help
Dynamically generated content
Book Recommendation??
Multiple "With" commands - Please help
Text Import Macro Help
unique file names
Maximum Rows inan Excel Spreadsheet
Maximum Number of Rows to import
Maximum Number of Rows to import
Dynamically generated content
Progress Bar
Turn off Excel's 'want to update info?' prompts
How to import multiple image files into spreadsheet
Help with VB script please?
Goal Seek macro
Pulling Data from Range
command button-print
Re: Copy continual, refreshing records to a new sheet
Sending Outlook mail through Excel
What time is it in New York?
Changing source for series collection in charts
Command button - won't execute twice in sequence
Can I slow the rate that VB executes individual orders?
Dynamically generated content
linking spreadsheet nightmare
Could really use some help with this macro.
Saving Excel document blows up Infragistics menu in frame
Sorting sheets in Workbook
Sorting Sheets in Workbook
Sorting Sheets in a workbook
Exporting charts as GIF - error
Exporting charts as GIF - error
Sorting Sheets in a Workbook
Weird Excel problem
Excel filename command line parameter to VB
Message: The macros in this project are disabled.
Macro expires
Linking different workbook
Linking different workbook
Using Protection on a Spinner
Locking Protection on a Spinner
Interface not supported
on mouse over
Sorting by date, then calculating totals
Exporting data from Excel 2003 to MS Project 2003
Error in Sending Email via CDO
Range Names
Returning the range name in VBA
Selecting a cell value in VB for a Query Table
Returning the range name in VBA
Delete Rows Based On Content
Wrong output
Performance issues, looking for alternate solutions
Returning the range name in VBA
Excel/Visual Basic
Delete Rows Based On Content
Quick question
Excel/Visual Basic
for each...next in reverse
Excel/Visual Basic
Error 1004 update autofilter and pivottable
For each...next reverse
Again about Row Highlighting [HELP]
Please help!
how can I put a cell reference in a header/footer?
For...next in reverse
General Mail Failure with SendMail
Is it possible to run DOS commands in Excel?
Separating one large workbook into several smaller workbooks
Wrong output
Japanese Excel and English
How do i download excell to my pc? please help
Draw Picture using VBA in Excel
Multi-user dilemma.
Find and Display / Modify code
How doable Using Excel?
Suppress warnings when saving text file?
Someone must know
VBA Compatibility Between Excel 2000 and 2002
Data Filtering 'Show All' macro
Publishing an interactive spreadsheet
sensitive button
autscrolling textbox on modeless userform
Sort - fill in - unSort
Searching using part of a word rather than whole word in vba
Pop Up Messages when saving a file
sensitive button
Accouting & Database
Selection is set to Nothing on second run of a AddIn function
Searching using part of a word rather than whole word in vba
Security - Delete File
Searching Data using Macro
copy random rows
How to catch Drag-and-drop in Excel 97?
formatting text/number in a command
do you know how to take out the 011 from this number:011548926 in.
Is it possible to run DOS commands in Excel?
Calling Macro by different TextBoxes
dynamic name range in VBA
Calculating the difference between hours
Inserting a SUM Function
Records in a form?
VBA code striped off?
Copy Number Formats
Records in a form?
Searching a filename from multiple workbooks or drives
Distribute calendar.ocx within an excel file ?
Pivot table data source
Toolbar 'Hiccup' problem
<Method 'Range' of object '_Global' failed> error
Re: preventing / converting 'illegal' characters in file-save text string
why can't I additem to multi-column this way..
Delete ComboBoxes using a macro?
Esc key to exit form
Checkboxes and DropDown menus
Global vs Local variables
Excel Help File Hyperlinks not working
Combo box to filter
Click event to run only once
Increment a Variable Defined Date by 1 day
build array of columns
Accessing VBA subroutines in another workbook
Opening files
Adding checkbox on a row when data is entered in first column of that row
Auto open 8 workbooks in different folders, then save on close...
Esc key to exit form
Calling Macro by different TextBoxes
How do you Change Column heading names
Calling Macro by different TextBoxes
Nested Ifs
Replacing Excel Add-In
help please
Label - Caption not changing
nagivating rows and columns
Use a simple Drop Down List or User Form
SIMPLE UserForm w/ 2 OPTION BUTTONS
How do I make a VBA procedure available to all workbooks?
Writing Out Numbers as Text
Label - Caption not changing
linking spreadsheet nightmare
updating spreadsheet from textbox
Footer : Last saved date
Quotes in VBA Code
BeforePrint event
Date/Time Picker
How do I paste from clipboard to range using Excel VBA
Searching concatinated fields
SIMPLE UserForm w/ 2 OPTION BUTTONS
Problem with "Range"
Disable Close "X" button on User Forms
select multiple cells
Disable Close "X" button on User Forms
Increasing cell date by a month
Existence, Search, Test
Counting Cells that meet criteria across entire workbook
How to show index in a chart
Range.Validation Questions
Copy a worksheet without 'opening' workbook
File names
Problem with Find filling a listbox vba
Naming Variables
renaming
Sheet protection
Formatting Multiple Worksheets
Re: Passing an array or recordset to a stored procedure
Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency
search range, if exist, copy cell
VBA Conditional formatting
Quick question
Create an ADO connection to current sheet
Excel 2000 AutoFilter and Worksheet protection
custom charts not accessable to all users.
hide/unhide cell when clicking a cmdbutton
Reads entire *.txt file into string opposed to a desired line by line input.
Help with Macro Recorder Please
Calculating the difference between hours
VBA Conditional formatting
LoginID
delete name range
Turn off Excel's 'want to update info?' prompts
Delete is Pressed then Stop
Re: Passing an array or recordset to a stored procedure
InputBox - cancel button
Combo Box Standard code
IF formula headache
Pop Up Messages when saving a file
Application.worksheetfunction
Pop Up Messages when saving a file
Automation error???
Editing a protected sheet
row selection
Excel VBA basics
Selecting text in cells & half of the Selected Text to be underLine
User Form Frame size
How to allocate movement if expected last record is missing
get day from date
DDE Initiate does not work
worksheet function or programming_urgent
export chart as jpg
VBA in other countries
Option button
linking code across different workbooks
Save and Close Pop Up Box...After Save and Close In VBA
Different length moving averages
Different length moving averages
Spreadsheet to .txt.
Menu Editor
Msgbox w/ multi-lines
How to keep a picture in Excel 97 page footer/header?
Help with Macro Recorder Please
SIMPLE UserForm w/ 2 OPTION BUTTONS
Hide a cell using Windows Script
how to detect when cell contents has changed
autoexecute macros on open or new
Copying text file into worksheet
Macro Subtotals
Re: Passing an array or recordset to a stored procedure
MSComm32
Copy/close web pages
Extracting Hyperlinks
Adding name to a range of cells
help please
How to use Names in VBA
how to create "template columns"
Can this formula be used in VBA
Dynamic WorkBook Linking
userform with mailto
Cell format and User form question
need help opening text file
userform always on top?
EUAC EXCEL FORMULA
Compatibility with Excel 97 Questions
Help is needed for modifying this code.
Re: Recording data from refreshing, imported sheets
Excel VBA - Search And Replace Cell data
MsgBox Replacement w/ an UserForm
MsgBox Replacement w/ an UserForm
Quick Question???
Calculating the difference between hours
Assignment problem
Chart formatting - CommandButton
Calling VB from Excel
Help with ComboBox Please
Researching single pairof data problem...
comparing dates
MsgBox Replacement w/ an UserForm
Help with Calculation
help please
User Form focus
Compare Date in Cell VS a Variable Date to Hide Row
find highest number display the complete row
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
Problems with select case
If-Then-Else resulting in DIV/0 error
number too long
Using IF to locate specific text string value
Dimesnion a variable on the fly
If-Then-Else resulting in DIV/0 error
get linenumber when string found in VBE codemodule
Finding MIN, MAX, and average
RE: Auto tab
Finding MIN, MAX, and average
Script to add hyperlink to Excel cell containing text
Calculating the difference between hours
Resources
MsgBox Replacement w/ an UserForm
Calculating the difference between hours
Line item calculation
FormulaArray and Ranges Question
MsgBox Replacement w/ an UserForm
Delete Rows with particular dates
Calculating the difference between hours
MsgBox Replacement w/ an UserForm
ComboBox and 2 Dim array
Msgbox w/ multi-lines
combine code to get data in one sheet
Folder List
Help with a User Form problem please
don't understand whats wrong with this userform
require password each time a macro is executed
Data from userform to worksheet
How to create a "xla" add-ins and active it.
How to call a "xla" object itself?
Colour Cells depending on time
Return OLEObjects values or names - two examples
how to protect VB script
Row Count in Clipboard
Re: FormulaLocal / FormulaR1C1Local not working
Stopping an excel macro while it is running.
Remote shut down of Excel
compatibilidad de excel con foxpro
HOW-TO: Determine if a cell contains a number vs. formula vs. reference
Data from userform to worksheet
Userform Editing/Access
FormulaArray and Ranges Question
Simple Selection Macro
VB programing
Macro or VB Code to Summarize Info.from 4 workbooks
advanced macro for find replace
Alt + Enter hotkey - what does this do?
Generate all possible combinations from three data sets?
Ensuring UserForm Textbox Entry is numeric
Formatting charts, problem with deselection.
Workbook_Open question
Disabling Ctrl-PgUp and Ctrl-PgDn
Sort/Filter by date
Finding difference between two columns
Linking tables
Please help with programming
Macro Help
User forms that are generated at runtime
creating array using name references
Addin, Funtion
Re: ADO Function
Format function question
Re: Removing Excel password.
macros
Setting the Options of the Find method
VBA Invoice Open New Window
Trying to identify what is not there
Using VB to change Combo box selection
ComboBox and 2 Dim array
Modify Web Query using macros?
Setting up a personal menu using VBA
How to use macro to open an specific file
Help! Please! - - - PLEASEEEEEE!
Re: Excel 2003 object model
Dialog Box/Form Help!
Automation between Access and Excel
A question about Userforms and tabbing
Checkbox and button snag
How do I set a macro to run when I click a Command Button in Exce.
Re: Link spreadsheets by clicking on a field
Re: Get Data from Selected Cells
Compare all following columns when value is same
Help needed with basic MACRO
Index(Match...
find replace function with a database
Checkbox and button snag
Help needed with basic MACRO
Re: Get Data from Selected Cells
Help needed with basic MACRO
If Then Statement
Get Data from Selected Cells
Re: Is .xls password protected.
find replace function with a database
Using VB to change Combo box selection
find replace function with a database
Modify - look at files within subfolders
Check if within Function Wizard
Excel windows media player links
Update of cells does not work from VB6
minimum value in range
How to refer to a listbox
Get ActiveSheet name in VB
characters that do not print
How to increase rows beyond 65535
multi column list boxes
Screen shots capture
HELP
Combo Boxes
export chart as jpg
Closing a worksheet
Userforms???
Automatic change for time constraint
Disable Splash Screen
Date Logic Locking up and not calculating
export chart as jpg
End Double Sub
Re: Automatic change for time constraint
Automatic change for time constraint
How to create a .XLS file instead of a .CSV file
Date Logic Locking up and not calculating
Creating a Dashboard that will change according to KPIs
Automatic change for time constraint
Can I save an excel file as a particular cells value?
Ctril + G in 2003
why are the options on my forms menu greyed out?
RefEdit in VB6
Creating a Dashboard that will change according to KPIs
End Double Sub
End Double Sub
Call Sub Procedure object_Exit(ByVal Cancel As MSForms.ReturnBoole
Writing to a text file
RTD Problems
Select Range - using Offset ( 40 ,0 ) - not working
Deleting An Access Table
MsgBox Spacing of Characters
If-statement in Macro
activate excel tooltip
Programmatically increase the row # in a formula
Excel.Union returning two Areas
If-statement in Macro
How Many Simultaneous Users Can Be Safely Handled?
End Double Sub
How Do You Get ISNUMBER() To Work?
Automatic change for time constraint
question about Auto_Close and WorkbookBeforeClose
Email from Excel....autosignature?
extract cell reference in one formula and add it to another formul
want formula
MsgBox Spacing of Characters
Click event to run only once
create multi-field, with layout, user questionnaire to save reply.
Listbox that dont refresh automatically
Sendkeys and active windows
help for teacher!
macro to transpose cells in Column B based on unique values in Column A
How is time represented? How do i make an equation representing 5 minutes?
MsgBox Spacing of Characters
Excel and VB
help needed
Embedded files in Excel
How to open an excel file from vbe in hex format ?
Multi-select listbox help!
UserForm_Activate not found
How can I Improve query speed?
checking variances in cells
calling Word from an .xlm macro: how to?
Automatic change for time constraint
Counting literals in cells
Colour Cells depending on time
Run-Time error 1004????
Save/ Send as webpage ?
select all cells with comments in a specified range - two examples
data subtotals is not working correctly in Excel 2003
Probably the most easy question here...
Call a program from Save As dialog
Excel causing exception error upon opening the document
Can VBA accept input from a message box?
SHARING MACROS VIA ADD-IN (.xla) FILE
print range name over multiple pages
password protection
Do same thing to each workbook found in a folder
Control Notepad from Excel
CheckBox question
Closing a workbook programmatically
side-by-side worksheets revisited
add sheet if statement
Importing Outlook Items into Spread Sheet Eats RAM!
Exporting data from Excel into MS_Project fields
Instructions within VBA Functions
First textbox in form not accepting input properly
Annoying Pop up box in function
Is it possible
Selecting and formatting cells
Annoying Pop up box in function
Deleting sheet
Combobox Question
Instructions within VBA Functions