View Full Version : Excel Programming
Pages :
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
41 |
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
[
115]
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- change query path
- Getting data from a workbook without opening it
- sendkeys problem
- CountIF on two conditions
- Message Box Improvements
- Starting macros when cell changes to TRUE
- Getting error "Too many cell formats!", how do I correct?
- Re: warning/error message
- Macro Help
- ByRef argument type mismatch error?
- Go to another macro
- Data import/extraction question
- Setting up a List Box
- Runing part of the macro
- Macro Help
- webquery loses format of leading zero and to scientific
- need a formua for wages
- bar graph colors?
- Copying spreadsheets in directory into master spreadsheet
- Sending Workbooks via Email
- Cell data validation
- Getting the row/column number
- how to use a macro to copy cell formats from one workbook to anoth
- simulate a enter key behaviour?
- Correct Syntax for Calling other Subs
- PING ... Bob Philips
- Setting sheet.xlt for a workbook programatically
- clipboard cannot be emptied
- Variable not defined compile error
- cuting some text from field
- Automation Error : The Object Invoked Has Disconnected From Its Clients !!
- Pivottable problem
- Yahoo Chart Into Excel
- copy formatting
- code to check a: drive has a disk in
- coding help again
- error - copy
- range = range
- Trouble with validation
- A VB code for creating count down timer / stopwatch...
- find pagebreak
- Excel pivot fields and trailing spaces
- Excel Process Doesn't End :-(
- message without stopping execution?
- option group on excel sheet
- Command Button Problems Still
- userform
- Excel 97 vs Excel 2002 coding
- Line colour of .SeriesCollection.NewSeries?
- active a set of VBA code once the cell have data.
- Disable command button
- excel 2002 vs.
- Binary operations (left/right shift, binary and/or, etc.)
- So easy you will probably laugh
- Formatting MsgBox Text
- Where is the computer's archive?
- Enable Command Button 1 & 2
- copy then paste a chart as a picture
- Delete sheets with "@"
- Placing a form inside of a form
- Message box when date expires
- Find & Delete Rows
- Excel in VSTO
- Cell lies within range
- Userform Objects
- "Subscript out of range" error for: Workbooks("Test1.xls").Save
- Need coding help.
- Access toolpak program from Addins
- Summing a whole column
- page number middle of sheet
- Calling a specific version of Access.
- sub call with string
- Excel Macro or VB?
- EXCEL-VBA, ADO not connecting to a TXT file
- Complex formula?
- Copy formula
- Need to fix the number filed so all numbers are 8 in length
- How do I find the number of elements in an Array of Strings?
- Referencing a Range
- Find the Format Type of a cell
- Help me clean this up...
- Workbook Copy
- How do I create a Macro?
- Freeze IDE or other strategy ???
- Formula
- SaveAs Protection
- test
- Error: Sub or function not defined
- Split Function
- Password on Save As
- Problem with TRIM function in Excel
- Referencing a Range
- Find the Format of a cell
- Paste Function Value
- Referencing a Range
- how get value of status bar sum?
- disabling right click
- Excel 2003 - Error Running Macro
- Rename Textbox on Worksheets
- how to update a pivot table on shared workbook
- SQL question
- Split function
- MsgBox Display
- Problem Running Code in Excel 2003
- add form with excel 2003
- Fill Down to variable row
- vba and conditional totalling ... WorksheetFunction SumIf ?
- Protecting a workbook
- VBA Recording wrong... whats the deal?
- RUNTIME 424 OBJECT REQUIRED???
- ofind
- Dynamic Array problem
- setting up a hopefiully simple macro
- Summing Like Element Array Values
- Excel linked spreadsheets
- Generating Ranges in VBA
- Can I autofilter across multiple worksheets?
- Turn ON Autofilter Filters
- Can I autofilter across multiple worksheets?
- Runtime Error 1004 Select method of Range class Failed
- Draw a Clickable Button on XL Title Bar !
- Save As macro
- Favorites.xla
- Creating a virtual table in VBA Excel
- Creating a virtual table in VBA Excel
- Controlling Word from Excel using Mail Merge
- slow code needs tuning
- Drawing a clickable Button over the App title bar ?
- Need help to convert formula
- Fill Macro
- Copy non-Zero columns to new location macro
- Range varying in for loop
- Copying cell data without the formula
- Problem with Option button control in multiple sheets
- paste table from pdf to excel
- paste table from pdf to excel
- worksheet change event with .NET interop
- paste table from pdf to excel
- paste table from pdf to excel
- getting a cell value from another spreadsheet
- When does entering data into cell end?
- Specify ScrollArea in a Sheet
- In Excel 2000, how can a macro look for the next empty cell?
- How to avoid deleteing certain rows?
- Help with creating template for users, need to protect cells, but...
- Summarizing Data from other spreadsheets
- paste special
- Running Dialog Sheet when opening Excel File
- can't use Application.Run() with apostrophe in file name
- List Box Help
- EXCEL FORMULA
- Variables
- pivot field definition in VBA
- pivot date/sort show
- pivot zero values
- pivot zero values
- pivot date/sort show
- Weird Mouse Problem in VB
- pivot zero values
- pivot field description in VBA
- Get the Excel Filename after a save
- Better way of finding last row on sheet
- Filtering based on row
- VBA Precedence Problem
- Find Min value in range with VBA?
- Finding the Value (of text and numbers) between N/A's
- _Workbook::SaveAs(...)
- coding error
- Excel on PDA
- custom function
- Version # in excel
- update txt file
- Trapping an invalid email error in Excel VBA code
- Create Function to display name of variable
- original messages in the reply
- Missing Numbers from a Range
- SaveAs CSV problem
- FileSearch FileName using wildcard (?)
- Do Until problem
- macro code to change file-opening password
- Add 0 to the beginning of the cell
- Controlling toolbar available
- problem passing an argument to a sub
- Re: using an if then statement call a caption box to a cell
- Default to Read Only
- using an if then statement call a caption box to a cell
- Help!!! Alerts in Excel!!
- Programming Question
- using an if then statement call a caption box to a cell
- Move the cursor to a cell in button click event
- Event of the dropdownbox in a cell
- Calling a common XLA Library file, stored on a network drive :)
- Calling a common XLA Library file, stored on a network drive :)
- Cell has a value of #N/A when the formula refers to nothing
- Complicated "what if, then" formulas
- Delete the list name from a cell range
- Auto sorting multiple ranges on event
- Custom Menu Focus
- =IF(B3<O;nodisplay(graphA);display(graphA))
- Subtotal Truncate
- How can I use 2 diff. recordsets without opening another db connec
- Excel Worksheet Subtotals Data Truncate
- combining tasks
- Hide cell range in worksheet
- Mysterious " " in SaveAs Dialog Box
- Splash Screen Problem
- Please take a look at this working code and critque it.
- Array Formulas in VB
- Formulas
- How get sum value in status bar?
- Prn file carriage return deletion within notepad
- custom function
- symbol
- Shoving Excel Columns Into Word Table
- Outlook Email Reference
- Question for dummy
- Refresh pivot table on a Shared workbook
- RE: Change size of comments?
- Batching files through a macro
- selection.copy is getting nixed
- Conditional Search & Cut and Paste *VBA?
- Debug RuntimeError 1004 in Chart
- Remove Invalid Phone Numbers
- Cell in Header ?
- pivot row field definition in VBA
- open file from folder save in new folder
- Display color (or Format Cells) dialog in a macro?
- open in old directory save in new directory
- Userform runtime controls & Macs
- Error check on sheet
- moving columns and selecting for copying
- Can I....
- Paste Special???
- copy but don't overlay
- execute code in one worksheet when change occurs in another
- class module?
- Re: Change size of comments?
- Summation with a Condition
- How to create a message that appears when opening an excel file
- Stuffing a picture into a header
- Condition IF problem in Excel VBA
- Condition IF problem in Excel VBA
- Colours in pivot tables
- Extracting choice from a ListBox
- How To Delete an Excel Macro by Using Automation
- Autofilter & delete lines
- Web query against MSN Money
- FileCopy Command Giving "Subscript Out of Range" Error Message
- How to minimize a userform!
- How to determine if a connection is active
- Using An Add-in On A Network Drive
- multiple pivots updated with selection in one table
- pivot field of fields
- Hiding Rows and column's
- Email Sent or Cancelled
- Add/Run macro programatically OLE error
- copy one cell to range of cells
- Allowing entry only once
- Questions with Printout and Close
- create autosum macro along with notation
- viewing SQL when MSQERY cannot attach to DB
- Using sheet names in menus etc
- Simple function made difficult
- Extract Path From String
- Importing data into Excel
- active x radio buttons in excel
- data grid
- serach using a cell value
- sequential numbering
- Excel2000 VBA: How force the procedure to wait until queries are refreshed?
- Help On Pulling Data By Column Headers?! Thanks!
- Odd or Even
- Can macros/functions interrupt formulas?
- Macro to edit a formula.
- Finding links
- refer to unknown window name
- Mail Single sheet as HTML(HTM) file
- Changing a pivot table page or data set by using a macro
- error when I save workbook to network server in Excel 2003
- Office Automation - Capturing Custom Menu Clicks
- Radio Buttons in VBA UserForms
- Copy selected cell in column and fill in blanks
- TextBox BackColor
- How to mention a range of validation list in VBA?
- Xth Weekday of the Month/Year
- How to reference worksheet name with spaces?
- return multiple results from stored proc
- Auto Set Print Area
- Dynamic Data Validation
- delete vbcode dynamically
- list of linking cells
- Coping formula down
- macros don't work if opened using IE
- Just another error message
- How to run a macro in code
- Using Loop to create Array
- 100M = 100,000,000; 100k = 100,000
- Assigning cell address components to variables
- Master details in 2 dropdownbox
- select vs. activate
- Solver: 2nd function of SolverSolve
- sendkeys problem for telnet
- excel cell and data formatting
- removing digits from one column to another
- compare and extract using a program. i really need help.
- Scroll locked in multiple worksheets
- Formating Body When Sending Mail
- Create a newworksheet with VBA code and put VBA code in the new worksheet module
- Closing excel userforms
- sum monthly to get quarterly figures
- Textbox keeps moving
- Application.ScreenUpdating MsgBox
- number of rows returned by autofilter?
- File listing in excel
- Counting unique text/number cells from a range
- HOW DO I AUTOMATE CREATION OF JOB SHEETS?
- Columns Selected Array
- Can you call VBScript code from VBA?
- Random error 91
- Error 91 - Sometimes happens, sometimes it doesnt.
- Autofilter - 3 conditions
- Combo Box Filtering
- Last column
- paste grays out after function performed
- Trap SheetBeforeRightClick event from another workbook
- "File Now Available" For a Read-Only File
- Creating Toolbars
- Timed Macros?
- Roundup / Rounddown function
- Strings
- Set Excel Author Option?
- Matching data macro in VBA
- Function doesn't work correctly with protection on
- Using a Variable to Reference Workbooks
- Copy Data from External Spreadsheet
- Assign Range - Inactive Worksheet
- How sort my working sheet not the main sheet?
- Stop user selecting more than one sheet at once?
- what can classmodules do
- capitalization rate mortgage equity analysis formula ellwood metho
- taking data at end of column and sending it to cell in another workbook
- Referencing a cell, not the value
- Another Data Validation question
- Invalid "format string" argument in Format fuction
- Data Validation question
- Matching data rows from two different sheets into a new a new one
- Wait for Pivot Refresh to Complete
- What is wrong with this code?
- I want the calculated date value of a cell to be the TAB value...
- ActiveWindow.SelectedSheets.PrintOut
- position of inputbox
- Re: Use Autofill in a macro to fill blank cells until next text -
- Disable macro in excel automation with VC++/Win2k
- Excell Newbie Quesion Please Help
- Multipage on a userform
- Prompt a user during a macro
- Pivot Table (same level hierarchy fields)
- Pages on userform
- Help with the Macro.
- SQL syntax
- VBA Validation
- Formula For Each Row
- Linking Workbooks
- Truncating Ctrl-shift > Edit > CopyPicture
- HELP!! Exporting formatted text file
- Two (probably) simple questions, but not for me....
- Accesing to excel macros by COM
- Importing data from one workbook to another programmically
- VBA Trouble with Hiding Rows
- Sending fax from Excel
- Run excel in visible mode from aspnet
- remove duplicates using vba
- Calling Macro - Will it take variables?
- Hi All - Declare Decimals
- Select Text in TextBox
- run a macro at a set time
- Change column Delimiter programmatically
- complex "if" statement
- User Intervention Required When Opening Workbooks
- variable form control
- Search and Analyse
- put user and password into a web page
- Excel -> Macro -> DTS ??
- How to deactivate cells without macro references
- 1 normal form
- Browse Button
- Setting spreadsheet defaults
- Looping thru columns
- PivotItem.Visible
- Problems with filtering!!
- Help with active X combo box
- How to paste without formatting
- VBA, Conditional formatting, Days outstanding count
- copy sheet without links
- Need to Wait for 'Print' or 'Close' (VBA)
- can you make a password active after a certain date?
- Re: How do you loop NON-SEQUENTIALLY?
- calendar language
- How do you loop NON-SEQUENTIALLY?
- rename worksheet
- Run-time error '429'
- Event handler in a cell
- Dropdown box in a cell
- Keep the scrollbar at position
- How to 'RUN' a worksheet
- Link Problem Can a MAcro do this?
- How to make a row unscrollable
- Excel2000 VBA: A problem with worksheetfunction MATCH
- Add values to a dropdown box
- Very newbie
- How to make a dropdown look up box
- Button to copy sheet, rename sheet sequencially.
- RE: How to highlight active row and column?
- RE: How to highlight active row and column?
- Copying a Value Down a Column for Every Value in An Adjacent Colum
- Excel - Find & Replace text in a string
- Command Button
- Summing columns after insert rows
- (in)definite article and leading/trailing space remover needed
- I can't remember how to...
- Chart.Export failure on certain machines
- merge multiple files from text list of file pairs
- random list in excel
- RE: Recorded macro won't run
- Change Background
- Insert worksheet
- VBA Protection
- Inserting a worksheet into an open workbook via VBA code
- Chart Macro
- Can I embed a WORD document in an EXCEL spreadsheet cell
- loop code needed
- What's in a (macro) NAME?
- Re: finding the number of rows and the first row with a specific value
- Re: Length limitation of cell formulas
- Re: Look for value in a column and delete
- Re: How to get a macro to work in different workbooks ?
- Re: Look for value in a column and delete
- Re: Time format and various users
- Re: Range Names-VBA
- Re: finding the number of rows and the first row with a specific value
- Re: Further help on delete criteria found
- AutoFilter
- Re: Time format and various users
- Re: AutoFilter
- Macro Writing
- Re: Flaky combo boxes. Work around?
- Re: Printing selected rows
- Re: Look for value in a column and delete
- Re: Macro Writing
- Re: What's in a (macro) NAME?
- Re: AutoFilter
- Re: Improve code
- Re: How to get a macro to work in different workbooks ?
- Re: Code problem with text box
- Non-adjacent area selection
- Problem with a recorded macro to create two pivot tables from same data
- Re: AutoFilter
- Date Modified from an External Internet Source
- Re: Referencing .Net DLLs
- RE: Recorded macro won't run
- Re: UserName
- Re: summing comma separated values in a range
- Re: Length limitation of cell formulas
- Copy data from Cell to Cell
- Re: Improve code
- Re: Data>val question
- Re: Combining multiple Excel files into one html?
- Re: Range Names-VBA
- Re: Improve code
- Re: Further help on delete criteria found
- Re: Non-adjacent area selection
- Re: Macro Writing
- Re: What's in a (macro) NAME?
- delete row if no data, non-contiguous range problem
- Re: What's in a (macro) NAME?
- Re: Combining multiple Excel files into one html?
- passing argument problem ??
- Specify Printer and Prompt for Number of Copies?
- XP Styles in Excel Form
- automatically send email in excel based on value/macro guru stuff
- Changing Range in Forms Drop Down Without Selecting
- Offsetting Cells
- Runtime Error 6 Overflow
- averaging N rows in column B which have a certain number in column A
- Copy data from one workbook to another
- maximum as to the csv data that can be downloaded in to Excel
- delete all rows above a selected cell
- time-stamping macro
- Can use arrows after App.InputBox
- Advancing from Cell to Cell on Key Press
- I have a kind of complex macro or vb script I want to program but do not know?
- selecting a range
- Help with Enabling / Disabling Menu Items..!
- Data Conversion ?
- Highlight Value of Text Box
- Not understanding If Not..Then nothing
- Fancier Protect Sheets, Workbooks
- Help with Macro: summing together/roll over rows (Energy Trading, see example)
- How do I change an integer into hh:mm:ss
- Ending Looping Macro
- Remaining Numbers from a List that are not used
- multiple workbooks reference
- A Login Macro, (Inputbox & MsgBox)..Need help with a counter.
- How to format Series with VBA?
- How do I create pop ups in excel?
- Why xlAxisCrossesMinimum works as xlAxisCrossesMaximum
- overcome from the restriction of number of IF statements
- Copy Workbooks and Paste into same spreadsheet
- Web Query output, how to format?
- How to move cells with VBA?
- Update links within a spreadsheet
- validation
- vba project stopped working in excel 2003
- Help with a dropdown list
- Selecting a Range from an Offset for deletion - Help please
- Exporting data to text file
- shortcut to open file in personal.xls blocking file's macros
- selfcert.exe
- #N/A Shortcut
- Programmatic schema mapping, XPath.SetValue question
- HOW TO DISABLE ALL MACROS in BeforeClose event handling procedure
- "Excel CLOSE" ERROR
- Sizing a Chart Sheet to a Word Table Cell
- Apple to Orange
- PublishObjects To A String?
- If page does not exist
- Numeric column in Excel
- Toolbar with macro
- how do I code 'before:' and 'after:' in vbs
- be able to edit datalabel position of all series in a protected ch
- Be able to edit position of datalabels in a protected chart.
- What object is it looking for?
- How do you Print with a loop?
- menu bar & chart menu bar
- If Statement: How to test if a cell is merged or not?
- How to if excel is running in a web browser
- Pivot Table : How do you know where they are (scanning all sheets)
- Need help for Printing Macro.
- Help with lookup code
- macro help please
- Project-Library Error
- Re-POST: How to close forms opened from other workbooks...?
- Copy and email
- Dynamic VLOOKUP from external, closed workbooks
- Send V to com port
- SQL Results, Totals, Updates, How to glue this all together ?
- Excel Range Value issue (Excel 97 Vs Excel 2003)
- tearing hair out - Listbox collection
- creating a 'routine'
- Please HELP!!!
- Re: Textboxs as dates
- Help with saveas ftp file problem
- Time needed for the group function: big diff between Excel2003 and Excel2000
- PasteSpecial problem in Excel 2002
- Need macro to analyse a column
- Ontime procedures
- Update sheet after changed Interior.ColorIndex
- use excel sheet in a different language
- Subscript out of ranges - Friend8899
- If Image. . .?
- Run Excel Macro from Command Line
- How use =now function and how to retrieve data from another shee?
- Start Excel Macro upon opening of document
- Auto calculation on a userform
- Problem with the end of this code
- Data Validation Listbox problem
- Help w/Protecting a Pivot Table through many unique passwords
- Problem cuz of Hidden sheet
- Organization Diagrams in Excel 2003
- lookup
- Can you Import & Export toolbars...?
- How to close forms opened from other workbooks...?
- MultiColumn ComboBox Value set/display
- Workbook_BeforeClose
- Can anybody crack this VBA problem?
- How do i get VB to reckognise an empty cell when excel thinks it's
- Formatting e-mails after creation
- Problems with Excel VBA application
- Remove all manual page breaks
- Strings
- how do I write macro to copy the value of a cell to another if va.
- Spin Button
- Can't protect chartsheets in my workbook
- DisplayAlerts = false not working
- DisplatAlerts doesn't work
- VB code help
- Menu Item name
- Day of Week and Date in same cell
- Taskmgr from VBA
- Need Urgent Help!
- vba goal seek 2
- flash cards
- Refresh BackgroundQuery fails
- List of available printers form?
- Custom Menus & "Begin a Group" option
- Write selection
- Comment Text Promt
- Sheet Offset - is this possible?
- before close problem
- Trying to switch to a different sheet in a macro?
- sorting
- Workbook/sheet protection doesn't seem to work
- Anyone know why this wont work?
- Macro recorder
- Workbook opens really small after protected
- Create New Workbook - Name book - 4 Sheets - Name Sheets
- TEXTBOX - VALIDATE DATE INPUT
- Combination: DataValidation auto appear + show all rows
- Formula For CTRL+SHIFT+;
- form textbox wont word wrap
- Zoom event
- supressing a message in vba
- How to make sheet continuosly re-calc
- Adding rows
- Name Surname combination
- Using ADO With Excel
- add text box values
- how do I package an application in Excel?
- get all sheet names in comboBox of activeworkbook and export when selected
- display correct toolbar icon on starting excel application program
- cumulative time in excel
- simple function question
- Custom Function: Detecting the cell the function is used in
- How to Make a Loop count by 1% not 1
- Save a BackUp of Workbook
- Manually Update Listindex
- Export to Range from Access with TransferSpreadsheet
- find last row, add "Total" in col B & border
- Retrieve Index of Activeworkbook?
- Possible too - ADD Text While editing a cell
- Password Seen as Stars
- Divorcing 'referenced' workbooks
- Use of Sheet CodeNames to Select Sheet in Different Workbook
- How to make values of spreadsheet show in a modeless forms text bo
- Using Macro to save form to file
- Using a save window with VB that works
- Add new inventory list to existing list
- Break a long row of code
- String converted to date
- Paynter Chart
- Won't accept range name
- Can you help me to improve this macro?
- "Clean Me" Macro is giving "#VALUE!" error in the Notes field.
- Multiple Choices in a cell with HLOOKUP
- busted workaround for 255 character limit in cells
- pastin' in my worksheet
- inputBox if cell >" ?
- How to remove a Java Script
- How to Switch the ODBC connection in Excel
- Form Input-->Submit
- Question on design
- What formula to transfer data from yesterdays s/s to todays?
- Store Variable with Exported Worksheet
- Re: Can VBA determine if a cell/range is in a group?
- naming ranges with VBA
- BeforePrint Add In
- Can VBA determine if a cell/range is in a group?
- Excel Addins Not Loading on Start
- Linking excel and acces¿¿¿¿
- Macro to capture cell value then use it for a relative range selec
- Issue with owc11.dll
- CTRL+Page Up and CTRL+Page Down
- Slooooow PageSetup
- Code works intermittantly is there a fault?
- Pivot Table Black Down Arrow
- ThisWorkbook BeforePrint
- Counting Letters
- Re: large validation lists
- Dependents
- Issue Commands To a DOS Window
- email sheets 2,3,4,5 ect. to users from a list on sheet1
- Wrap text in VBA
- Sheet Size
- GetSystemTimes
- Help in copying range
- Dynamic range copy.
- merging cells/data using a Macro
- How to hide VBA from others
- Comment shows on open then deletes itself
- Spell Check
- parameter has multiple values seperated by value
- Unique Dynamic Validated List
- Problem with closing workbook in macro
- Function that returns worksheet name and updates on rename.
- an afternoon with a dot and a commer...
- Finding Cell Contents
- Drop Down Menu
- Comboxes
- Code to transfere all cell data in one old file to a new open?
- Simple String Conversion - HELP
- Direction problem in inserting strings using right to left language
- Time Sheet help
- Macro to sort worksheets alphabetically
- Control Display Area
- Pivot table is not refreshing problem
- Workbook_AfterSave Event?
- Macro to Make a Macro
- print dialog box with 2 copies as default?
- Using an input box to search for a value ...
- Window Error when deleting shapes
- Move all files from one directory to another
- Need code to compare cell values in a column
- How do I convert a selected Cell address in a Range to Values?
- Set an Excel generated CDO email's priority or importance to 'high' or'highest'...
- Comparing Formulas Between Worksheets
- Changing Cells format using VBA
- changeing date formats when not intended
- Mutiple Instances of Excel - Which one will Windows use to open a file?
- reference 2 arrays in a For Loop
- Numeric field overflow. (Error 3349)
- Advance filter search does not filter an exact match
- DROP DOWN LIST
- can I add to a defined name in a macro?
- can I add to a formula in a macro?
- Re: Cell Reference is Worksheet Name in VB Code
- userform printing
- Cell Reference is Worksheet Name in VB Code
- Sub to copy a target sheet from slaves from and paste/overwrite into master
- Counting instances of an offset value???
- How do I access a variable from another instance of excel?
- Predictive Model Needs Macro Timer!
- Stop SetLinkOnData
- How to compare multiple cell values
- Cut and Paste to DataGrid
- Footer font formating in Excel
- Linking with Outlook
- getting filenames from a user selected folder
- Limit text length with inputBox
- Update Columns based on External Text file
- how do you use a variable a rage?
- User Form Question
- How do I insert a preformated paragraph into a comment?
- Displaying a selected value from a combo box
- VBA Code for selection rows
- Pagebreak function problem
- import from web
- Excel Com Addin
- how do I create a macro to "Go To" a location specified in a cell?
- Assining the value of a vlookup to a cell rather than the vlookup
- Create Multiple Worksheets from One
- Movefile "Permission Denied"
- Bitmaps in custom toolbars look awful...
- Closing a workbook without saving from Word
- Excel MAcro/Printing
- Data Parsing
- Hide Rows From a Row to Last usedCell.Row
- Changing visible (filtered) cells
- Insert
- getting it to work
- Filtering in a macro
- import blank lines in excel 2003
- Information Box using SaveAs xlHtml
- Changing Name Range based on imported data
- Find and highlight results macro
- Simulate Click Event
- how have status bar "Sum=xxxxxx" use commas=>"Sum=xxx,xxx"?
- Searching a database in excel
- EntireColumn.AutoFit - Slow on Large Files???
- VBE Window not working correctly
- Auto-prompting to change the links source file
- Setting Default of Checkbox based on value of combobox
- difficult but supposing not imposible
- Me.PrintForm -> landscape
- creating new sheets based on specific data
- VBA Code help - first timer
- Can I move images in Excel forms?
- relating to named range in vba
- Pivot Table calculated items with dynamic file source
- What can cause application.screenupdating=false to not work?
- My code does not run on another computer
- Call Macro from another WorkBook?
- Need Macro1 to call Macro2 stored on Network drive
- Programming automatic data entry?
- Refreshing Data Pulled Thru a Function
- Too Many Line continuations?? VB Macro
- Slow Saving
- Userform Control Type
- FAQ? Searchable archive?
- Update Links - Startup options.
- filling an aray without looping
- ADODB is unable to copy more than 255 chars in excel cell
- ADODB is unable to copy more than 255 chars in excel cell
- Excel 2003 Pivotchart Macro
- More help needed with listboxes
- Specific Row Designation
- another VBA newbie question
- I cant do a search on this forum. Everytime I search, it comes up with zero results
- Conditional actions
- can I assign a macro to a cell?
- Help sending Lotus Notes mail through VBA - one last piece!
- 'ActiveWorkbook.Names.Add Name:' how to make range variable?
- incrementing columns in a loop
- Stop running a macro in the middle of a macro
- Can I build a sentance from data tables in Excel?
- Filling a listbox with transpose of a range from an excel sheet
- Copy Macro
- remove duplicates
- Shapes and VBA in Excel 2000 and 2002
- Dynamic input range
- range construction
- Refreshing Pivot table Pull Downs
- Open a specific worksheet in workbook
- Cell Ref to identify worksheet
- Minimize Form
- optionbutton
- Vendor Sourcing Tool
- Function to return Character Position of Xth character within a string
- Comparing charts after cut and paste
- inport txt file automatically
- Webservices References Tool 2.0 - Error: No Deserializer found ..
- count data
- Can't load or unload object
- Simple, but I don't see it
- How can I keep the format of cell content when I copy it to text b
- Date format changing on edit > replace
- Form
- Adding Separator Menu Item - Excel 2003
- empty columns
- macro compile error
- How do I bind a list in Excel to a combo box on a userform
- How do I alternate a sort from a text box via macros?
- How do I alternate a sort from a text box via macros?
- WorkSheet Macro Help!
- Excel as an OLE DB consumer
- Find a row and a specific cell in that row
- Can I create a macro to identify and delete blank rows in a range?
- Multiple sheets using single chart
- How to get font of particulat word in text inside a cell?
- Unable to run Excel addin procedure from Word
- Can I fill a spreadsheet thru the Internet
- Shared Workbooks
- Threading Problem
- Dumb Delete Question
- Formula result incorrect
- Keeping track of code
- Validation input message box
- How do i open a new instance Excel?
- Writing text string with imbedded quotes to a text stream
- Sum Formula in Macro
- Protecting Spreadsheet
- What does this mean?
- Jump between sheets
- variable for columns(??).property
- Shared Workbooks
- is there a better alternative to Copy/Paste?
- Changing row height conditionally
- macro for self destruct
- Managing Add-Ins
- Value based Text Colors
- Excel doesn't have enough rows
- Choosing items in a list box
- Merge worksheets in "Share Mode" (Excel 2000)
- visual basic
- Excel2000 VBA: First workday of month
- Can I sort a table using a macro in a protected worksheet?
- Assigning a macro to a button
- Inserting a drawing object into a cell
- Accessing "AllowEditRange" without unprotecting sheet
- UserForm R1C1 problem
- Uppercase a text box
- Properties of a jpg
- How do I denote values stored in columns in my macro?
- remove last part of string
- Current User or Author Stamp
- On Error and Loops
- Excel 2003 Userinterfaceonly Password Protection Problem
- Type mismatch on range name
- New to Excel + VBA - Need help...
- Delete All Files in a folder
- Calling an embedded items event procedure from within a normal module
- How do I convert peak-peak voltage to rms voltage in Excel?
- VBA Excel formula error
- Application-defined or object -defined error
- Excel VBA macro crash
- Changing the year only in a date
- Creating an event procedure question
- problem with reference
- Conditionally format row height
- why do white areas in raster images print spotty
- page setup with Excel4 & Waiting Form
- Dates and Input Page Help!!
- Why am I getting this message
- I'm a newbie
- Compile Error
- How do I access an unopened spreadsheet from a program?
- How do I Paste thie answer into specific cell using vb...tia sal
- Writting to Word using an array
- Combo dropdown open
- MS Query
- clear contents cells of unprotected cells
- Goto a dynamic cell address within a macro
- Excel 2000 Macro
- Solver Error
- Email Macro Late Binding
- Delete a command button via VBA
- how do i change font size in msgbox
- Macro doesn't run on new machine
- Importing an Image (jpeg) in Excel
- excel to html
- Excel to Word
- Delete Macro from VBA
- Application.Interactive=true ignored?
- Shrinking Listbox
- Freeform shapes
- Double Numbers
- Supressing the Macro security message programmatically.
- Sending Userform data to different sheets
- Class Module & Module
- Is there a NET-Control in VSTO similar to RefEdit?
- Hooking TIB R/V to Excel 2002 RTD
- EnableOutlining with shared workbook protected sheet?
- Excel crashes after quiting
- template 4 proj cost analysis (sales value - expenses=profit)
- Creating a toolbar
- How can I copy cell content to a text box?
- Color of cell.
- User Form
- Sum a lot of box in different pages
- Workbook_BeforeClose event is not canceled
- ActiveX Control Events dropped | lost | blocked - Excel / VBA
- Send To Mail Recipient
- excel conditional formula
- Duplication
- Renaming sheets from a list
- Close Visual Basic
- RE: change audit
- Summary sheet in a workbook
- Running an Excel Macro as a Scheduled Task
- Renaming File Statement -How does it work??
- Subtotal Column Labels error
- Auto Excel workbook close: save= false during an auto subroutine
- x in checkbox
- Microsoft query issue
- Extracting value from Combination drop down-edit box
- exporting CSV numbers become text
- Days in a month Function
- Updating multiple layers of links
- Error, Worksheet Will Not Open
- How Can I Prevent Data Entry In Same Category on the Same Date?
- .PrintTitleRows
- How to "show all" items in a Pivot Table via vba
- macro in vba to display autoshape
- data validation
- Macro Question
- remove all hyperlinks
- Resolving percent and date formats as such in concatenate function and emails
- RE: change audit
- Using a cell value as the subject line
- Clumsy VBA Code for Chart Source Data from Loop
- Array loses data type when placed into range
- For Each in Range
- Checking File Attributes of Excel CSV over Inter/Intra Net
- Place code from current workbook to new workbook
- In Operator Equivalent
- Editing controls after testing
- How to Create an Excel file?
- How do I synchronize two similar Excel files?
- telling VB: if cells(a,b)="any number" then ...
- format question
- Trouble with VBA data assignment
- Overwrite Master sheet when using merge macro
- Save As macro
- First double-click lost?
- Simple Question: Select Text Box from Spreadsheet?
- Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
- Re: Worksheet feature help
- Re: Worksheet feature help
- Lookup multiple values on multiple sheets
- Fibonacci function/command in excel?...tia sal
- Worksheet feature help
- Where is the timer activex control in MS Excel VBA?
- Password protection
- Where to sell custom apps?
- Save without VBA code?
- Arrays
- Range Question
- Working with 2 workbooks
- Can't get CF to work properly, Active Cell problem?
- Language of the local PC
- Auto filter and Next Row
- Calculating Averages
- Comparing double values
- I have a VB related question,...
- easy question about FaceID
- Activecell - Probably very easy question
- Supress Query Refresh dialog on opening workbook
- last row in ANY column
- Forward planning (networkdays without last 2 parameters)
- Q. How do I code a column to insert current date, when I double-click?
- Application Function
- external data (detailed)
- store chkbox.caption in array
- refer to dynamic range in closed workbook with ADO
- error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error
- Macro to know if Cell is Text or Number
- Autofilter including incorrect rows
- Changing the Worksheet ScrollBars Color !
- VBA Query to Excel, Stuck.
- Footers in which number of characters exceeds 255
- picture scrolling?
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.