Excel Programming [Archive] - Page 45

User Permissions
copy WB without VBA: copied sheets link back to source WB
Connect to Sharepoint List and Update Values from Excel
Code replacement
How to close All Workbooks
Userform Scroll Bar Doesn't Update in Real time ???
Autofilter +Create Sheets
RibbonX: Problem with OnLoad
how to format a date to be used in sqlstring in excel 2007?
Certificate not trusted
Unique values in a macro
Macro malfuntion
display cell only if it contains a value
Overcoming an Error Message Q
tricky password
Use lookup to write to cell
Subscript Out of Range ... Setting Page Breaks
Please Macro or Formula Help needed
Displaying Text on a Forms 2 Form
Save a shared file as webpage
Default commandbutton
Empty a cell if the values equal to "IN" , "MC" or "PP"
Auto Populate multi cells
Extract Cell Contents to String
How to: if a range is not empty don't allow close?
Return Rows of Selected Range in a Pivot
Delete rows containing same value in two columns
Creating PDF from Excel Using PrintToFile
for each character in a cell
Help with code: Security and web queries
Simpler way for nested If statements (VBA)
Create macro to load custom toolbar
Code into MS Object Sheet Hangs up
User Form
conjugating 2 sheets. pleae help i'm already late for the deadline
Call a Control_Click Event when UserForm is Initialized
Excel VBA DAO Data Control
Error code 13
Automate Excel download of csv file without proper URL?
Error: can't find project or library
Drag & Drop in ListBox Ctrl: Find pointer position on mouse up?
Macro generates "Type Mismatch Runtime error"
Need Help with Pivot Table
Chart transparency
MACRO TO GET BALANCE FIGURE
Select Cell and open UserForm
copy to next blank cell in colum
Pivot Table Calculated Field
Macro to grap certain cells and copy.....
Series function& protect sheet in excel 2007
Test if a file is password protected
IF and OR Functions
XML and DOMDocument
Refresh workbook changes without saving
Shared Excel worksheet
excel
add new worksheet after specific sheet
Open Workbook Assignment
userform from scratch
Paste and Paste Special options are disabled
Paste and Paste Special options are disabled
Paste and Paste Special options are disabled
Help with search code
Scrolbars
how do i get word conversion number to text in excel (100 = "hundr
Form ScrollBar Help
Custom Function Desired
Need help creating a formula
In Access Can't Run Excel Macro Through Automation
Dynamically Building List
Macro to Find a specific data set and do a count
Add records to sheets based on a variables table
Automatically Excuting a Macro in a different workbook ?
parameter to open file name in macro
XL Odd behavior interaction between dynamic range andSheet_Deactivate macro
VB/VBA to read Task Manager
VB/VBA to read Task Manager
VB/VBA to read Task Manager
Copy Formulas
Truncate Left Characters in Cell Value
Pivot Table based on data in protected cells
delete checkboxs
Passing Variables between Workbooks
range.address, replace characters
Renaming files in a directory
Copying data
Excel Justify
renaming a page doesn't stick
Last Used Cell in a row??
refreshing a multipage
Error Application Defined or Object Defined
date format conversion
Change Event duplicating action
How to change the default caption of a workbook to the full pathname?
List all internet explorer (or other) windows (and close them)
Displaying YTD for each Month Selected
Sub to copy n paste as values based on an "instructions" table
M I`5'Persec ution ' BBC Newscasters Lie & De ny T heyre Watc hing Me
Re: Disable Menu (CommandBar) if not workbook is opened
Showing text on A Userform
naming my worksheet
Re: [SPAM]
2 userforms, 2 UserForm_Initialize()
Text Box Enter and Exit Events
Worksheet Change Event Does Not Work When Reopening Excel
public variables, 2 userforms
Assigning a hotkey to run only from a given range
A "chessboard" problem
Peter T's Copy WorkBook Contents Copy
excel security
setting focus to particular textbox
etract unique data from multiple workbooks after extracting data
making a different sheet active
Run Excel macro from XP shortcut menu
Creating first excel addin
Memory leak
Error retrieving data from closed workbook
urgent ?
rotation of an arrow created by an drawing object
retrieve data from Access Database
worksheets
Catastrophic Failure -2147418113 Lost Project
Userforms, switching sheets
Help with code creation
OPENFILENAME A P I. User cancels ?
open and printing workbook with vba
Separate Numeric Values
Fiind the newest file
Getopenfile
Detect page break preview
Passing Array Formula result to a variable in VBA (Leo)
change color of command button problem
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use...
Saving a file every fifteen minutes
“Merge” data from 2 Excel files
Remove extra space within text
User Defined Password
Name of Current TextBox on Userform
A Little More Advanced Range Fill-In
Macro Conversion To Relative Cells
Vlookup on a VB Form
zoom problem ??
Create A GUID
Image popup (as comment) when you mouse over.
Add a period to name initials
do...loop with timer problem
caculations letters
finding only numeric values in a worksheet using vb.net?
Ribbonx - how to create two ribbons?
VBA password removal - how many tabs?
about .exe file
A #NAME? problem with a transferred function
refer to an object in a group
Multi Workbook Data Extraction
reference to external ranges
How do I start a Process I can then communicate with from VBA
toggle borders macro
Listbox load event
moving controls in X & Y axis
how to make a userform like the built in Data form
Lots of REM lines an easy way?
How to change the color of a page
Openform event
How to iterate through columns?
Copy range
How to tell if sheet exists in closed workbook
VBA to select the cells next to the result of a find & combine the
From Column to Row without blank cells
rotate highlighting colors macro
unprotect sheet failure
Open with Openform; Workbook not visible
Pharsing string from the right to the first space
Worksheet_BeforeClose conditional Worksheet change
Simulation
Can I open an Outlook dialog box from Excel?
create macro "merge selected cells"?
Custom List
expanding numbers?
Passing Array of User Defined Type to Form
Convert Text into Numbers
xls size doubles
cut and paste with loop macro
xlCurrentPlatformText
xlWorkbookDefault
toggle between autofilter Criteria1:= "*" and "all"
deleting multiple rows
data type mismatch error
Opening a file command doesn't work
week function in vba?
sort issue: Excel seems to be treating my column of numbers"alphabetically"
date confusion
getting the active chart/chartobject's name
Change name of pictures in worksheet
atpbaen.xla
parsing data
Turn formula into Select
Sheet problem???
Select different data label range (as values)
Speeding up execution of a Macro
Activating an open file with a variable name
combobox doesn't load cell value at startup
ComboBox.visible = False or True
Variable Case issue
moving to next cell without keyboard
autofilter next and previous record problem
Sumif function problem
How many pages will be printed?
autofilter row count
copying many controls
Error 55 File Already Open
Using variable to identify a workbook
splitting a file into two before importing it to excel
Superscrpts in Excel 2007 Text boxes
Username and password login.
Fastest way to save workbook
pop up calender in a userform
add certain fields in msoenvelope
Copy userform in msoenvelope
Need a faster way to update values selected by advanced filter
"Lines on 2 Axes" fails on Excel 2007
Can I have code executed after Save?
Trusted locations
User defined - conditional between statement???
Background color change, by using the formula.
Consolidating data from various worksheet of same excel file
changing value on a userform
combobox data doesn't take affect right away
Copy data
copy foo.xls whilst it's opened by Excel - are there problems ?
Discrepancy between manually formatting sheet vs. using VBA macro
Selecti Page in Userform by Name not Number
pasting from one sheet to another
copy paste is changing the cell value format.
Write Additional Data within a txt File
Create a calendar in VB with excel 2007??
Maximum number of controls on a user form
Onkey Key Codes for ADD and SUBTRACT keys in earlier Excel version
Named ranges disappearing in Excel 2007
A List of Collections and Custom Collections
Redefine UsedRange property of Worksheet Object
Looping through and array with three possible decisions to make
add lines to a order list
excel - inserting a formula in a cell (using =) fails
VBA "sheet" NOT to minimize while working on worksheet
Difference between 2 times
Worksheet copy without user interaction
Format sheets w/varying ranges
Extract MS Query Cell Address
LoadPicture compile error
Graphing by seconds
Determine if a PivotField is visible?
Security Concerns using interop excel
"Unreadable content"
if then else problem
"Sheet(1)" Syntax
Customized menues
On Error problem
Number Value Check Question
Using a form to edit data
Referencing a cell in VBA from a different worksheet
Retriving value from multiple sources
ExecuteExcel4Macro("GET.DOCUMENT(50)")
Counta with CountIf
Search Directories/SubDirectories UserForm
change formula dynamically
ListView - How to add checkbox column
Copy Columns to New Sheet
load data to cell comments
getting behind the Hyperlink
Putting large array into a worksheet
Array Memory Size
Simple method to webonize my spreadsheet
macros... again
Inconsistent Code?
Allow Edit doesn't forget
macros
copy worksheets between workbooks - including named ranges
about check boxe
macros
Suppressing the UPDATE while opening a file
Active Sheet
Date Question
Insert rows in many sheets
Modify function for another workbook
run macro although blinking cursor is active in an active cell
Add record to end of list, variables table
changing font size in an activex label
Excel VBA Evaluation of FormatConditions(1).Formula1
replace blanks with values above
Combo box change event fires twice
How do i copy a cell from a workbook to another workbook?
Easy One - do math with Textbox values
Addin Macro Call
Open a form from an Add-In
Workbook_Open() of locked project causing errors
How to obtain the names of all installed fonts
Clear Range
Percentage formating in macro
Variable Help
Copy and Paste Macro
List files on SharePoint
Excel 2007 Craches when closing via macro code
Close PDF files
VBA and Colorwheel
Attaching Macros To Items In a List Box
1 file- multiple headers, move columns to match first header
convert excel to VBA
PrintPreview error when run from VBA
Updating values using advanced filter - VBA
called macro
Close workbook without being prompted to save in VBA
Keep Timer Going While Altering Workbook
Sheet Code Name vs. Sheet Name
set focus to form
if not isempty combobox does not work ?
Module Name
Row Number
VBA to Select Cells with Conditional Formats
Condition formula
VBA Date Format Cell Check
Simple Multiplication Formula
Compatibility question
Drop Down List & VLOOKUP
Condition formula
Y doens't this work?
Mixing Fonts in a single text cell
Progress bar that is constantly updating
Easy One - Syntax for variables in TextBox & Label names
new formula after condition met
I need template for day trading
Counting ranges
UserForms to populate cells in a worksheet
Server Calculated Members in Excel 2007
Applying the target formatting
Checking Column Constraints
Print 2-Up
add listbox item for all sheet same range
How to count number of red font cells or rows
Limit textbox to 255 characters
Excel Validataion listbox
advanced filter, goto next line(record)
Removing vowels from words...
Last Item in Column
Windows file property access
area code
"Find all" and show the cell addresses in a MsgBox
click cell and get a pop up number pad the one used in ms money
Generate ongoing database of results via Macro
probably a relatively easy macro question....
Running a Macro Without Apparent Code
Toolbar macro re-named
Open a workbook with Notify option
Case Statement for Changing Font AND Background Color
Populate one cell with an offset cells contents
Indirect in Conditional Formatting
Trace dependents in protected sheet
comparing amounts
Range help
Excel copies graphics from one sheet to another arbitrarily
Replace a cell (I2) with a cell (H2) if I2 = "a"
Selecting multiple tabs in VB
Associated Worksheets
Method 'Columns' of object '_Global' failed
Variable count and bound random numbers
C# Excel Automation AddIn Help message
searching data in XML from EXCEL
Help with calling word reference from excel vba
Limiting Size of Excel 2007 Spreadsheet
Naming Cells - need help
how do i empty the clipboard from within an excel macro
Excel User Interface - Performance Testing
Avoid Confirmation Questions
Change PasteSpecial
Form/Input box
Importing Text File into Excel loses leading zero on some fields.
Listbox horizontal scrollbar problem
(Reverse Union) Randomly draw address from Range
Sumproduct
Combobox List Drop on Entry
Problem with If-Then-Else Statement
Conditional Formatting to VBA code
Worksheet_Calculate fires for every worksheet in book?
Type Mismatch
object disconnected from client error message
Inputbox to return range from another workbook
Turn Off Circular Reference Message
auto date
Ressources about controlling html from VBA
Declaring subs Public vs Private
Macro for user defined Solver changing cells.
How to Call Functions in the Personal Workbook?
Importing data from excel to excel
Copy Sheets to another workbook
How do I write a macro for keeping time?
How to retrieve text from the textframe of an oval shape in Excel?
Conditional Formatting...
OLAP - use CUBE functions to sort on the basis of underlying set
Problem with saving documents as .csv file
Long running operations
how can I put the data from the second sheet in the first sheet?
Re:
how can I match the data from the sheet2 in sheet 1?
Hiding sheets using code
Can Macro command to open files?
Pivot Table changing sum values using VB
ListBox Column Widths
Macro for Solver with user defined changing cells
Reply
New to Macros
How do i seperate colums when special pasting information
BeforeClose running twice
Difference of HyperLink in Excel, between Windows XP 32bit and 64b
changing size of characters in a selectionbox and date in a textbox
Pls explain this VBA oddity
setting print range based on looking up values
mouse focusing in close button in preview window
how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
Blocking a Windows Message
cell.formula returns value
creating a userform
VBA Programmer Wanted for Short, Paid Contract
Run Code on Activate Sheet
Macro to copy values from a table
XLA Deployment
efficient / easy way to convert an Excel.Range to a double[,]
Convert Conditional Formatting Into VBA Code Button
referencing commandbuttons as OLEObjects
Variable Series in graphs
"Compile error in hidden module: This WorkBook" only appears whenproject locked
Insert email address from Outlook into ActiveCell
Insert email address from Outlook into ActiveCell
click in a workbook
Generating Graphs (XY scatter Plot)
Accessing ranges with integer variables
Copy doesn't copy in Sub Extr10L
Check for directory then create
need a alternating password
Find Chart Sheets in workbook
Area Select Tool
ActiveWorkbook.ConflictResolution
is there a "switch p, case 1 2 3 ...." flow control in Excel?
Excel Range In Word
Text File Data Formating
Not resetting all cells
End(x1Left) to column a
Goal Seek on multiple rows/columns???
EXCEL6 Window Class or Typed Value (WIN32)
CSV line feed delimitter
MergeCell range
How to position to a specific sheet before saving
selfcert.exe
conditional formatting in excel vba
Auto/Manual Calculation
Converting a GPS waypoint from decimal to degrees, minutes and sec
Using XmlImport to get dynamic data in Excel 2003
Copy Rows using criteria
command button properties
Search Modules for Cell Addresses in Range Variables
another code not working
application or object defined error on print to file
Splitting data on sheets for more than 65536 rows...
HOW TO CHANGE RANGE
Calendar not in a cell
From HKBN
questionnare
code not working
What can we use as an equivalent to "Sleep()" in vb?
Floating textbox/label
NEED CORRECTION IN MACRO
code to move images
Automatically copy formulae to next empty row
Copy excel chart as picture to a particular ppt slides
ConnectCode's new productivity tool automates removal of duplicateentries in Excel
choos one of two comboboxes
How Do I Use DispCallFunc with IMLangCodePages::GetCharCodePages
Is it a bug? in VBA, FileName (with "[", "]") changes after opene
Problems with Hiding/Showing Modeless Userforms
Combobox problem, please help this novice!
Calender not working in excel 2007??
Excel template usage???
Data Consolidation using dynamic path
Formatting not updating inside a function
error in setting chart area width
Combobox_Change event fires on workbook close
Screen "Flickers" When macro Starts !!
Default Cell Formatting
Comment disapears
LOOKUP VALUES FROM OTHER SHEET
Refreshing External Data
Delete Matched Cells
Macro to Lookup Exact Value
weekly report
Bias in rand for excel 07
correction needed
Where did Tools>Reference go?
batch file for collated printing
add a dropdown calendar to a worksheet?
profit/loss calculator
makro to log info in Access
NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
I want If and Vlookup together in one cell
Horisontal scroolbars problems
excel files will not down load from outlook
Open a dialog box
difficulty with percentage from worksheet as seen by VBA
Copying dada from multiple workbooks into 1 workbook
Need Help: Strange, Strange Behavior ( Not Me. My Model! )
Range Question
one per day password
vlookup ?
Formatting a single column
<xxx is not a valid add-in> error in Excel 2003 SP2
Help with Userform/Autofilter/VBA
Clone Sheet?
GetFromClipboard help needed please
enter text in cell just by selecting cell
dates in macros
indirect?
Please Help
copy rows to next sheet
Error Message
Tab Name
Emailing Activesheet As Body of Email
setting page breaks based on value & printing to and from value
information message
copy rows based on cell colour by conditional formating
TMOO - Mood tag<[email protected]>
ADO 2.7 recordset problem
Public variable not storing
labels
Name limits
If - End if problem
Problem running VBA 2000 code in Excel 2003
Re: workbook sharing entries at the same time
getting current procedure name
Pivot Cache error using Range object containing cell with 255 char
copy & paste columns to new worksheet
Offset & Range
Column label based on column index
Problem with multiple error handling
Dumping Data Into Excel
Add worksheet to workbook of calling procedure
highlight a list
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
Fill down function
if an element in a row is true then copy whole row to another shee
Getting unnecessary 2nd Page
macro to prit to pdf
Launching Standalone Program from within Excel.
Macro formats field with value
Worksheet tab won't update.
Remove passwords from many workbooks
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2
Sort worksheet tabs based on ASCII values.
Automation performance degradation in Excel 2007
PopUpMenu in Flexgrid - Excel2002
ConnectionString Timeout After 60 seconds
RE: macro to move data to new column
Excel Properties() collection
Compare values of cells in a range
worksheet range qualifier
Active cell hunt
Disable the Close button on a Userform
workbook sharing entries at the same time
delete columns
BeforeDoubleClick
PopMenu in Flexgrid (with Excel 200)
disable copy and save as
Decimal Places
Making new Pivot functions
How to ORDERBY Alphabets in ascending order?
VBA versus VSTO (fundamentally excell based)
file not there
excel VBA programmer, what is the value of adding access for data
quick Conditional Format question <--rookie here
hiding sheets using a form
checkbox to hide/show row
help
remove macros
VBA to sort blank cells to bottom <--help please :o)
Macro to Enter text
How can I make arrow keys skip over cells?
MsgBox Help
Activate Range for Workbooks Already Open
Excel 2003 VBA Help me complete this Search script
Return To Last Active Sheet
Excel to Powerpoint - Text Box Properties
Code for sending Outlook email with attachments using a list
copy rows based on cell colour
copy rows based on cell colour
DDE Link format question
Programmatically Extracting Validation List
adding worksheet with macro but need to get back to 1st sheet
Application.FileSearch in 2007
Locking cells after the user has entered values in protected works
question on excel 2007
Excel Calculations through VBA
Prime numbers
Finding a value in one of two columns
RE: CurrentRegion issue (attempt 2)
Import data from access problems
Need assistance with code issue??
locating cell that partly matches a text string
Display contents of text file in a listbox or textbox on Excel for
excel to CSV
Import data from multiple excel files in one folder
Month to Number format
Rounding formulas
Excell Random number
UDF that works under Excel 2003 but not under Excel 2007
Find Last Used Row
Unicode strings and Excel 2003
Problem asttaching macro to form button
deleting cells
Macro That Deletes Rows Extremely Slow
delete cells
Adjust series order in Excel 2007
Lookup
tlbimp vs. primary in VS project file
Open , Save, and Close Macro
Excel Interop DLL problem 2003
Macros missings
howto replace the order of adress ?
How to diagnose a COM addin that fails to load?
Data Validation by List
Paste data into another workbook but not overwriting original data
Age old business day with holiday entry
Check range of cells for non-null values
UserInterfaceOnly not being recognised
Update Custom Toolbar Buttons
Automation stumble
Automation stumble
Automation stumble
SaveAs without closing original workbook
Drawing on a Chart
Importing from another file of unknown name
Saving to Intranet Site
right click menu
pop-up calculator
Setting variable print areas & pages to print
HELP & Commercial
find numbers in text and put value in another worksheet
Application.Iteration in UDF
Conditional counting with multiple criteria
Moving data makes unwanted change to formula
UDF Optional variables become required in Add-In
Simple Excel formula
Re: Variable number of parameters in Excel User Defined Function
removing a macro
Re: Range analisys
VB error
Limit on Range Object
Insert Formula in Range
Simple VBA Macro to import Data
Userform Frames Occasionally Disappear When Form is Activated
lookup
adding combo/list box to msgbox/inputbox
looking up
VBA Excel Conditional Formatting <--rookie here
RE: Dialog Box
RE: CurrentRegion issue (attempt 2)
RE-Post Max Function not working properly on 2D Array
RE: Change all Links
RE: Elapsed period between dates
RE: printing with out data
RE: Elapsed period between dates
RE: CurrentRegion issue (attempt 2)
RE: Refresh Data on hidden worksheet <--help please
RE: CurrentRegion issue (attempt 2)
What am I missing here???
Keyboard Macros
Remove Pivot CommandBars from right click menu
Right() error changing columns in macro
WSEAS ( http://www.wseas.org ) is soliciting new proposals forSpecial Sessions and Workshops
Very long code execution time problem
I have a query about loops and random numbers
Date Question
removing special characters
VBA code, delete worksheets
Please help with my code
Using comma inside the comma delimited text in Data Validation/Sou
Help with user interface for charts
Select Case and If...Then Statements in UserForm not Calculating
Excel default workbook
Macro to extract data from webpage
Help required with 'FOR' Loop and Userforms
Repeat
Dot Trailers '...' in Cells where text is too long...
activating a page of a multipage control
Hide and Unhide Rows button
Determine if the sheet has been changed
VBA, copy unique values
Code hangs second time around
Problem with macros
Help with C. Pearsons code to VBE
coding for excel programming
Hiding Formulas
Naming Workbook
Copy Digital Certificate between workbooks
Split Cells?
VLOOKUP ERROR HOW DO YOU MAKE IT BLANK
WorksheetFunction
Textboxes not Calculating properly
Hiding Rows from VBA
Reading values into an array of User Defined Types
Input Box only if a cell is blank
Disregard conditional formatting if cell is blank
o -t does anyone see and speed increase after office 2007 sp1 is installed?
Copy certain rows from one worksheet to another
Multi Line Transpose Excel VBA code
Subtotal
Can't copy
How can I make an executable program from excel?
Sampling in excel
Seems easy
Problem with Deletion
Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
reset my format cell properties
Please help with Count
.find not finding corect value
Install Analysis ToolPak
How to pass selected cells into a delimited text string?
Refer to Public Variable from Another Workbook
With .Controls.Add(msoControlPopup)
Set Named Range with Last Row
Find blank cells and clear adjacent range
ID3v2 MP3 Tag Reading Class
Changing chart data ranges from VBA code
Deleting Columns - Causes Code Changes
Which is faster, copying range to another set of ranges or copying tomemory?
Programming to the VBE - Help
Prompt box when emailing via VBA
Macro Help with Variable
Excel & Word Password Protection
Min Function on 2D Array
problems recording macro_value or formula?
Referencing WSH in Excel (2002)
Automation error from RTD
VBA Code Optimization
Application dies when you use mouse wheel in listbox
bar graph from pivot table with two data fields
Form scrolling on its own
findnext error in loop
Importing DBF with large number of fields
Display the current value of an Options setting
Excel 2007 Buttons
Macro programing in excell
Check box problem Excel 2003
Syntax Error ?. Execution does not enter the Select Case
New to userforms - can you help with this code?
Unique ID on different sheets
Highlight cells containing words of a given type
Macro for numbers duplication
copying if value in cell from range of cells
Very Slow
Sending Email - different reply-to address
vba code for .zip conversion
How to get the number of Line/Column used in Excel sheet ?
referring to the button that triggered the macro
Sorting a Column in ascending order in excel vba
Selection.* not work
VLOOKUP Error N/A
Excel's Refreshable Web Query & Javascript...
Code to Slooooooow
RTD Server deployment
public sub worksheet_change ever possible?
How to make Excel More Interactive and Dynamic
Delete Rows Between Border Lines
Create a Macro to update File and Worksheet References in Formulas
VBA Button Size Larger
Setting a cell format based on a function operation
PageSetup Performance Question
Finding row number with .find()
Copy Cells
Incremental balance and progress bar
carrage return
Array function
xls file becomes larger
Query multiple database platforms from Excel
Determine ActiveControl on a multipage (tab) control
Create a Formula
setNumberFormat in custom excel function
New to VBA - What does this code mean?
Modifying J Walkenbach's data entry userform
Making Application.CommandBars.ExecuteMso method work in 2007
how to launch VBA in 2007
Adding UserForm Data to Worksheet
yet another Obj var not set
Pass control to a function/subroutine
format numeric data in pivot table
Macro to validate is cell is not empty and copy the line
MEET NEW ADULTS! 5000+ NEW PROFILES PER WEEK! FREE!
Populating a portrait orientated 'form' from Excel rows
New Forum For People Who Love To Discuss On Technical Topics
If or Case help - Which to use
Multi Page Scroll Bar
Pivot filter Help
Referencing Worksheets from Cell Values
PDF help!
Problem with deleting rows in a List object with center alignment
Numeric Format
Changing formula to Upper case
ERROR problem with Formula
transfer range of cells from excel to Acess using vba
Help with FindNext error
Please Help Splitting data
Sort and Match Cells
Storing variables in a macro and using those variables to performcalculations.
fill external data in specific cells of various sheet
fill external data in specific cells of various sheet
unlocking merge cells
Accessing a C# dll from vba
VB code needed
Combining text in a cell with a named cell value
JSP's form-submit & Excel's Web Query....
Access wab page with excel VBA
get data from web
Freezing Top and Bottom Rows
Codename passing
Create command button with VBA
Help !, problem updating data through userform !
Worksheet Codenames Passing to Function
Help - Routine to screencapture and save image?
Getting list of named ranges
Macro to create seperate sheets
Multiline Messagebox in VBA
tab to select combo box instead of field?
Extracting proper range address from multiple cell selections in V
Help with messy formula
On going formula
Odd macro performance. Explanation?
Find and Replace
DIVORCE FORMS
focusing mouse pointer to the specific button in a userform
How do I show 2007 custom Button Images with transparent backgroun
Matching a number from another sheet and copying a related value
Repost: Is Workbook already open?
MultiPage Scroll Bar
HELP: How to call UDF defined in another workbook?
Any way to word search in a Text Box?
Is there a way for a idMso button to display a custom image?
Easy way to test range as single cell
Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?
Finding row
Combobox.additem (No Repeats)
Using a TextBox in a Userform
Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?
VBA Programming Enviornment & Intellipoint
Help with pivot charts and vb.net
Loading an Array
How do I make all rows 7,...23 exactly 8 pixels higher ?
complicated change to formula (conintuous)
Use VB array as as argument for worksheet function
how can i crack password prottected workbook
subtotal
VB Right
what object var should I use for the following code
HELP: How to restore Immediate Window to original state?
custom view to display specific toolbars
Excel RTD,SQL Server and persisting range
COLOR INDEX UPDATING & FOR CONDITIONAL FORMATTING!
Continue to have issue with array in Subtotals automation
Replace value in cell with value from a table/array?
Specific Macros
An error occurred while loading image with relationship ID ...
Printing envelopes based on Excel table contents
Excel Converter Using C++
Workbook Sharing
Code for combining text and deleting row for c10 thru entire range
Out of Context
Userform to show and update data problem
Help with a form
Finding the difference...
Excel 2003 - Macro for Deleting Rows
Editing MS Project File from Excel VBA
How to know if Excel is still attached?
Try Again... copy a row if another worksheet cell <>null
Do function on worksheet open
Userform Question
Userform and Worksheets
find string in web page
Correct me if I'm wrong but...
How to delete duplicate record
Convert text to numbers
Search 1 worksheet then another for data in large workbook
Can I format cell to autonumber everytime I enter spreadsheet?
Tranferring text from Word to Excel
Setting Column Widths
Efficient paste from web page; also bring Excel to front
Convert to Number
sql stmt issue
Error Trapping Issue? WorksheetFuntion.Search
This used to work...
Unwanted Sub Exit, Ws in page break preview View
Enable To Run Macros
Pivottable filter
Excel 2003 - Macro for deleting rows
Validation List
Open New Workbook / Save and Close Current Workbook
vba/macro recognizing other worksheets open
Excel VBA Bug
Copy formula if other worksheet cell <> null
Find value, perform function, search for next value
If problem...
Is there a faster way
How to copy VBA array into range of cells?
Question for Userform Excel Wrksht vs Access DB
Speed test results if interested
setting label properties
Only matach two excel spread sheet
Ambiguous Name detected?
See the accepted papers, keynote lecture, plenary lectures, thecontents of the Book of the Proceedings (i.e. accepted papers). WSEASPost-Conference Report for the Conferences MACMESE '07 and DNCOCO '07 (124images)
Automatically close file
Range("A1").Interior.ColorIndex=xyz does not work
ReDim Preserve on 2D Array not working
macro toolbar button problem
Error handling on Workbooks.Open
Array help
VBA Commands
Sheets.copy problem
How to list items meeting conditions?
UDF with user help
Copy from one work to another
Two decimals
selecting range over multiple sheets
Hide/Unhide Sheet using VB
Copy a part of worksheet with active x elements
HOW TO IMPROVE PERFORMANCE FOR VB
Linking Forms across seperate addins
Delete non weekdays
Send multiple cell values to multiple cells
NumFormat problems when exchanging dot to comma
sub-range
Function or sub (add-in)
Can multiple selection available to copy to new Workbooks ?
Last saved by
Range Prompt
UNDO
Double Click on cell to goto - Help needed please
How to find out if an excel spreadsheet is already open
Aggregation on Column Value (groub by logic)
Can I draw an arrow at form using word macro?
Programming Macro - Sheet Specific
How to prevent change Numeric value to date format ?
How to control recalculation in VBA?
Custom Menu
Protect Selected Sheets
Match excel spread sheet with macro
What is the "VSTO way" for loading data into variables at run time
Filter Macro that can work for any column/active cell
Microsoft Office 2007 Compatibility Pack troubles
Sort Column
Populating dates
Lookup - copy.paste values macro?
A Macro to change various cells with a condition
macro to hide # of columns based on value
Find doesn't find...what the !@#$
Convert column data to trim all characters and leave the last 6
Add Column Names to VBA script
adding a row with a looping macro
how to recycle through cells in a selected range
Mouse wheel exception in listbox
Copy Contents From Worksheet to Another Worksheet
RefreshAll pivot tables but query
Conditional Formatting
Input box password
Sub add-ain
automatically hiding a cell when value changes
summing by color
Check if cell content changed
fomula comes to next row on click
when exiting combobox, this code moves the selected cell down two rows instead of one
Create Output CSV File Worksheet
Multithreading, of a sort. Or is it interrupts?
Help with formula
Crashing Bug in Solver.XLAM for Excel 2007???
Customize Addin
Need some VBA help
Loose formating of linked cells
Help with "Doubleclick event"
Reference Material for setting values for Form Controls using VBA
ActiveWorksheet vs Worksheets.Item(1)
Workbook name
Find text string within a named range
Display text and hidden value into a cell
To transfer data to SQL Server 2005
how to call statistic funtions from vba (Histogramm)
VBA application not saving properly
textbox problem
Help with code please
Help with VBA loop, lookup and calculate problem
Hyperlinks in Pivot tables
Atoumate the counting of Net Finance
Net Financing
Open File, pause macro until file is selected
Macro unexpectedly jumps to other macros and functions Options
flash cell colours from white to red and back again
Cannot set the row property
help me excel coding
STOP CHINA OLYMPIC!!!!!!!!!!!!!!!!!!