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 |
- Update custom outlook form from within Excel
- deleting blank rows
- Help! Excel Macro Delete function!!
- "Out of Context" Message?
- .NET remove .net code from Excel spreadsheet
- Need help passing an array as an argument
- Date as worksheet name
- Excel Date/Time problem
- Error with Form
- Add page breaks from VB
- auto-populating columns
- match problems
- CheckBox on UserForm
- Event for a file being changed?
- Spreadsheet Dropdown ?
- specific name for saving.
- Macro or VBA help
- How do I use VBA to add a formula?
- Re: Incorrect msgPrompt
- Add a multiselection list box to a spreadsheet
- What if AutoFilter is NOT on?
- Running Macro in Minimized Excel Window
- Re: Excel if & hyperlink formula
- Is it possible to load an .xls file
- Using Variable in Rows(x:y) function
- Q. Consolidating a long list, in single workbook.
- Create an .xla
- code to delete a defined name
- Does OnTime slow macro down?
- Macro Expert Help needed...
- Using LinEst function within VBA macro
- New to ComboBox
- Opening & setting data from Excel to webpage
- Excel VBA-Creating Menus
- IF THEN STATEMENTS
- Unprotecting Worksheets in VB Script
- How to change Text
- Msg Box
- Msg Box
- Msg Box
- Named range
- Directory List - Ron de Bruin
- combo box
- A Turing Machine in Excel
- Re: Grpahical selection of points on Excel charts
- How to make Excel the Top-Most application programmatically?
- general validation question
- Re: range class problem
- Buttons
- Re: Creating pick box with unique input values from a worksheet in the
- Simple table query
- Mail Merge Error
- Mail Merge Error
- Multiple Column Cell Compare looping through Rows
- Re: Populating blank cells with the data in the cell above.
- VBA Script to detect user input
- decimal & percent format
- activeworkbook.saveas - saving format changes
- Please help..urgent !
- function called from worksheet and bad result!
- Unprotecting!
- Unprotecting!
- Unprotecting!
- Filling An Autofiltered List
- Filling An Autofiltered List
- Custom Menu return to Excel Menu upon Closing
- Problem with TabBehavior on UserForms
- which declaration to use
- Insert Excel Sheeet using VBA
- Problem with printform
- Permission to use object denied.
- Go To Home
- Programatically navigate to depedent cell(s)
- Option of Print Preview or Save As
- need time calculation formula
- Autofill Destination
- How To:
- How to save a bar chart as an image file programmatically?
- Excel VBA: Create new conditions
- print userform (for MVA)
- cannot unhide rows!
- cannot unhide rows
- cannot unhide rows
- cannot unhide rows/columns in the worksheet.
- Freeze pane
- Excel Grid to Template/Form?
- Open Office Kills my secrets !
- Setting printarea through range object
- Help in Excel VBA Programing - How to check an Excel Worksheet?
- Recommended Book on Visual Basic for Excel
- Changing Cells, How to
- Trouble opening worksheet
- Check if empty
- How to justify in merged cells
- Remove reference names
- Problem with external_data
- Excel Chart Class/Object not work propely in IE
- If/Then Matrix? Can Excel do this?
- Object variable error
- Command buttons duplicating themselves
- Deleting named ranges by looping through range collection
- How to create new sheet in excel using VJ#.Net
- calling windows with variables
- Turn Off Scientific Notation
- Turn Off Scientific Notation
- How to set default font for forms?
- How to locate record in VBA of Excel2000
- Find
- Possibilities Enhancing Auditing Features?
- Rows Count of a particular column
- Rows Count of a particular column
- Using same VBA program in diff. Excel versions.
- VB Code
- Quick question about dynamically adding and naming worksheets
- Excel 97 - Prevent Renaming/Deleting Protected Worksheet
- code help cont.
- Re: If Statement
- code help
- sorting rows
- Filling a Word form from an Excel spreadsheet
- ComboBox on UserForm
- Command buttons stack up!
- Excel "Work"menu option
- filter code help
- DDE function
- loop to delete rows...
- Have a Macro create a Macro
- Multi Check Boxes (Selecting Just One)
- R1C1 vs A1 addressing
- Macro Names
- last cell in filter
- Help in opening powerpoint file variable from excel
- Dynamic Cell Selection
- Pivot code
- TextBox focus 4
- application.enableEvents
- dbx file duplicates QUESTION
- prevent coping from CD
- Populating other cells with combo box selection
- Copy and paste subtotal to another worksheet
- dynamic chart title
- Worksheet change subs.
- activating cells
- Device I/O Error
- CONDITIONAL DELETE
- Jon Peltier question: use of MATCH
- Excel/PowerPoint E-Mails
- Advancing A Number With The Push A Button
- Textbox error checK problems
- Excel <-> Application clipboard data transfer
- Infinite loop? Help.
- Create Concatenated List with Incremental Values
- ComboBox on UserForm
- combo box
- VBA / IF - Then / Custom Toolbar
- Number to text with leading zero
- How can I insert 4000 rows of Excel data into a sql database
- unique entries
- Excel Math Bug
- .Protect ET .Validation.ShowInput
- On Error GoTo
- Marking ActiveX control as safe
- Write no closed workbook ?
- button
- Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One
- how do you change a row height in a protected worksheet
- How to create a digital certificate>
- How to create a new sheet in VBA?
- file can not be opened
- Resource of excel to connection mssql to get data
- Excel bug, variables reset?
- Getting external data...
- Adding other bars disabled ???
- Scrollbar macros
- Help Needed to Search and Find Specific Data
- Protecting Macros
- Update Links on file open
- Use a RefEdit to select a single cell
- Forms Unload for No reason
- Which function to use to open an .asc file?
- Changing Text in grouped shapes
- enhance trace precedent via dialogue box?
- Disabling Circular Reference Checking
- Combo Box
- Option button problem
- Avioding "Version Update" Dialogue Box
- Using a Macro to Write A Marco
- Programming Formulas
- Excel 2000: Web Query not working for https site
- Text Box - Restricting Entry
- Writing to Network Workbook
- Convert CSV Files to XLS
- Dynamic Range
- Re: Reference Error
- specific cell values in two ranges
- combination of numbers in lottery
- Coverting worksheet macro to regular macro
- Populating Cells in a row.
- excel with project embeded in it
- Using Querytable.add to import data from a closed workbook
- List Selection to First Empty Row
- VBA Function to evaluate hlookup text string as formula
- Date Conversion Formula from Bob Phillips...
- Connect a Template with the data source.
- Opening a new file from a template
- Re: A development of a Macro by Tom
- How to create a "combination drop-down edit" box?
- Setting LinkedCell on a CheckBox Control
- Re: How to determine column letter in a spreadsheet?
- ICD9 Code Evaluation Function - an example
- Splitting first and family name
- Macro to copy text from ColumnA to B
- Immediate window error
- Listbox refuses to resize
- wrap text in combo box
- Macro compatibility between excel XP and 97
- Personal Settings Causing Error?
- Cannot assign value to Filesearch.Lookin
- multiselect on a listbox from Control toolbox
- UDFs: A simple question.
- Re: How to determine column letter in a spreadsheet?
- Microsoft Script: <x:Name>Auto_Close</x:Name> causes errors
- Error check and resume
- can not assign value to LookIn
- "value" works in sheet, not vba
- IF THEN ELSE in VBA
- VBA - Cells
- add a workbook.
- Kill Syntax and path
- Invisible AutoFilter Drop-Down Arrows
- copy to the same workbook
- Insert row if box on userform is checked
- Slow coding in VBA Excel 2003
- Wrting values with macro.
- Removing Outlook Warning Dialogs.
- Removing Outlook Warning Dialogs.
- Move to a specific cell
- Macro problem with protecting worksheet...........
- Help with Vlookup in VBA
- Linking Or Copying Filter Arrow
- Should be straightforward answer...
- Concatenate formula with relative cells
- Saving Excel 2000 files as .xml
- Empty keyword in statment Application.caption?
- Conditional splitting of cells
- Month end report ? expansion
- Conditional Formatting
- SolverOK, he not so OK
- Import modules EXCEL caused an invalid page fault in EXCEL.EXE
- Deferred Mail(2)
- Workbook_Open() not running
- Userform date format problem
- How to check that a string is a valid formula ?
- Pivot Tables Messsyyyyyy
- Code Execution Has been Interrupted
- Re: Left JOINS in multiple table MSQuery in Excel
- Excel 2000 V Excel 2003
- Re: Please help me improve macro to convert spreadsheet to tabular for
- Force a new Excel instance
- Detect Macro Completion
- Search "Total" in all worksheets and delete rows containing "Total"
- Copying ranges from one sheet to another
- information From Global Address Book into list box.
- Creating a powerpoint presentation from MS-Excel
- Combo box
- Returning range object from custom functions
- Cells.Replace need to keep track of result
- 6E+02 what is this ugly scientific format?
- Check active sheet not the one with macros
- Passing Dates to SQL From Excel
- Modifying an Excel Chart in VB - DOM question
- Macro Error(??)
- Create a days in calendar year add-in
- Re: Assigning 10x1 array to 2nd collumn of 10x3 array
- WAV Files
- Best Course to Import XML with DTD...
- if it looks like it matches, it's a match
- RE: Would like to add 0 counts to worksheet after data is returned fro
- Re: Assigning 10x1 array to 2nd collumn of 10x3 array
- Re: Need Help! VBA screen capture question
- Excel macro to control Word Problem
- Importing Text Data into Excel
- Macros with vlookup
- Select cells in a column
- Re: Macro with Query
- Re: Modules
- shifting headings over on column
- How to Process Query Data after Query is Refreshed
- shifting headings over on column
- Re: Modules
- For loop with non consecutive number
- User Defined Function used in Macro returns #VALUE
- Page Break Preview
- Directory List
- Convert Date Format of 7/29/04 to Date Format of 072904
- Excel 2000 VBA - Using Split() with no Lelimiter in string
- Break mode not working
- Need help with report output....macro???
- workbook-specfic Macro Menu in toolbar
- Autotext equivalent in Excel?
- SumProduct function
- Autosave
- How to find this value
- colorize celle from a range of date
- AutoLoad UserForm ?
- saving excel file
- compare two ranges in different workbooks and copy data to a new workbook
- Print Excel files without Blank Pages
- Re: saving excel file
- VBA code for Excel File Save As
- XL2K: ADO's Find method (once again.)
- Query in Excel...
- question about the macro vb some one help?
- Query in Excel
- Re: Resize Dynamic Ranges
- Input Box Code Please Help!!
- How to extend a standard class (like Worksheet)
- Groups and coding...
- Can I do this with a TextBox?
- created form, want to require input
- How to Mute/Enable Windows Sounds whilst running VBA code
- Removing Range Names
- Run macro after Pivot Chart refresh
- Worksheet Change Event
- How to insert a bitmap image into a Excel Cell?
- Re: Resize Dynamic Ranges
- textbox
- Resize Dynamic Ranges
- List boxes
- sizing columns in code
- How to insert a bitmap into Excel Cell in C# program?
- Tim
- Event Procedure Programming
- How do I convert Dates from Text back to Date format using macros
- XL & Access 2000, ADODB and the Find Method
- Get source from a web page into a worksheet
- Finding name of last user who modified Excel Spreadsheet
- When opening a worksheet I want it to go to a specific cell
- auto Filter broken - frozen?? please help
- "Refresh Data" Question
- Re: Insert blank row between data
- Using named ranges in a function
- Copying ranges from one sheet to another
- Publishing Worksheets as Webpages
- Using a field to let user +/- from values.
- Macro Modification Help
- Unsafe ActiveX Controls Issue
- Re: ActiveSheet.Printout
- Excel - Visual Basic Complie error
- Conditional Formatting Formula
- Calling Macros From VB6
- recording
- Re: saving files in a macro
- Excel VBA - String concatanation problem
- Help a Newby Please!!
- Runtime error 91: Objust variable or with block....
- memory problem with excel
- TextBox focus 3
- Odd results getting files properties
- Array Question
- Number display in formula bar
- A fun but not essential problem...
- Deferred Mailing from Outlook
- Problems with solver and vba
- End-of-line markers in tab delimited text file
- Printer Set Up in VBA
- Compare and delete cell?
- How many new customers every month?
- adding XML element using Excel 2003
- Why I get "Stack overflow" err 28
- SORTING AFTER AUTOMATED REFRESHING OF DATA
- Excel Macro help
- Chart is being dumped into the wrong sheet
- append row
- Re: Retain SQL Login information for Microsoft Query using Excel VBA
- Adding data from Excel sheet to Access database
- Is workbook open on the network?
- Copy and past drawing objects name problem
- Insert VBA code with a macro in a .xls file by workbook open event
- Consolidation: Combining groups of identical items
- Shell Command - Net Time (Cannot create text file)
- changing the source cell for an embedded/linked object
- moving worksheet to another workbook
- Help on nested loops
- how prin in cells by using vb macro
- auto download file everyday
- Delete/Hide PivotTable PageFields "(ALL)" Option
- Cell Echo Help Required
- Need Excel Solver Add-in
- Converting to tabular format?
- help with displaying information
- Macros and if statements
- Assign Results from If...Then and Loop to an Array (VBA)
- Re: Would like to add 0 counts to worksheet after data is returned fro
- Keep my activecell on A1, no matter about the cursor
- Scope of macros
- Help reading binary file
- Problem with using the "Like"-Operator.
- Re: Excel VBA Test For Blank Cell
- Macro to hide rows based on a zero value in a particular cell
- Random Function in VB
- Missing movements from kernel32?
- Can you sort a list based on catagory names without useing a custom list?
- Click Button to Load External Data Into Spreadsheet
- Need Help: Dynamic Range
- GetSaveAsFileName
- Re: ThisWorkBook BeforeClose Event
- Re: ThisWorkBook BeforeClose Event
- Using variable names in formula
- Combobox
- RE: If-Then Formula
- RE: If-Then Formula
- Error 1004
- How to select a celrange?
- Web query - using cell contents as part of URL
- Multiple-step OLE DB operation generated errors
- Re: saving files in a macro
- Resource / Time consuming macro
- VLookup problem
- Please HELP VBA problem!!!!!!!!!!!!!
- Re: Help getting code to work.
- Trying to set cell value using macro
- Inserting CGM images in Excel changes image aspect ratio
- Need Help Please
- Excel VBA Test For Blank Cell
- Process data in a sheet within workbook using SQL query?
- Excel VBA Test For Blank Cell
- Selecting a worksheet with a ComboBox
- Conditional formating
- Programming command button to execute on a different worksheet
- Line continuation error
- Problem running a probram using SQL 2000 Job Scheduler
- Replace with total
- SendKeys to a remote server application
- Feeling beatup by Combobox
- CommandBar code does NOT work if Excel is Already Open :(
- Publishing an autoupdating Excel Worksheet
- Count Rows with VBA
- Re: Date in userform being saved as general not date which affects sor
- Find folder with next to latest date
- Help getting code to work.
- Searching and matching the textvalues in specific column ranges
- Subscript Out Of Range Error Message
- Re: Subscript Out Of Range Error Message
- Macro to Create text file from range of cells?
- Help
- Dynamically determining .From address when using CDO
- countif help
- Macro Help
- SaveCopyAs
- Opening and pasting in active workbook
- Please help..
- Scroll view doesnt work in Code
- Cascading ComboBoxes
- How to check cell data
- detecting row or column insertion & deletion
- Picture scaling in Visual Basic
- Data Formatting
- Re: Need help on challenging question
- File name into a variable
- Programing buttons
- Manipulating a Range
- Access query vs. Excel query
- cell entry
- Removing text
- opening and viewing an access-database
- Re: button in sheet
- Formulae to sum up values including special symbol?
- Excel 97 VBA - CURDIR, not reliable
- Re: button in sheet
- Cells format
- code interferes with function charts()
- Hidden Macro
- setfocus on multipage tab form gives error message
- Need Help with interesting Find & Replace macro
- Excel importing of .csv and .xml
- Excel 2003, XML, databases and macros
- Changing Cell location within a formula
- Addin for Excel - general doubts
- Alternative to SendKeys
- modifying conditional format
- VBA to VB
- Worksheet_Change problem
- Add-in not working
- Excel VBA -making Objectnames variable
- Invisible macro?
- Excel 97 macros in cells?
- VBA - hyperlink
- comments' pos
- File size grows enormously
- Workbook opened with macros disabled
- BEFORE SAVE
- colour text
- Check rows and paste
- Crazy problem when using a WHERE-clause in a SQL query
- help wanted urgent
- help urgent
- help urgent
- help urgent
- Copy PasteSpecial
- Disable Save As dialog on ReadOnly spreadsheet
- MS Query & Criteria
- macro coding
- Data Validation Boxes and Ealier Versions of Excel
- Using Cell Contents to Reference External Workbooks
- Find ColorIndex
- Linked excel objects in word, and my resulting problems :)
- Linked excel charts, changing filenames generates exception
- help: selecting rows within an equation
- Userform - Label Caption - How to update from a variable
- Replacing characters with leading zeroes
- can vba import code to vba project ?
- Dropdown Rowsource
- Programatically Entering an Array Formula
- Select Sheets via Array Macro
- avoiding hang when formula is being edited
- VBA QUESTION
- Combo Box Question
- naming ranges
- Lookup...maybe
- Locate all occurrances of a value then transfer to 2nd table on another sheet
- Locate all occurrances of a value then transfer to 2nd table on another sheet
- Using array to select rows to copy
- disable print option, not Workbook_BeforePrint
- value lessthan x and greaterthan y
- Problem updating Excel using ado.net
- declaring a public array
- Disable sheets tabs right mouse button!
- How to Reference Global Variable for external application.
- Re: inserting a row with data
- Help with xlDialogsSendMail or other way
- Macro from a different workbook
- SpecialCells used to enter data
- Next Empty cell after Row A10
- Command buttons etc
- Counting records in a filtered list
- Keeping user-inputted data with pivot table contents
- sql.request
- Re: readonly attrib on a open workbook
- Adding Range for Search
- Re: Run-Time Error 1004
- Self-Resizing Formulas
- Help with VBA/macro for Excel data
- Creating a new sheet
- Converting a Date to a string
- Converting a Date to a string
- Excel Clipboard Problems
- Re: Importing web data to a VBA Array
- Unprotect and protect....
- using functions as parameters
- using functions as parameters
- If Satement Modification
- Deleting Duplicate Rows but keeping the most recent.
- What's wrong w/my code?
- Re: Adding values in textboxes?
- sendmail issue
- SeriesCollection
- Simple If Statement
- Haeder/Footer param
- Find text in Column to sum
- Freezing panes?
- Help กกกกกก Please
- summing range
- AutoSave a WB copy everynight at midnight
- Re: Right Function Doesn't Exists in Excel 2003?
- Launching other Applications from Excel
- Run-Time Error 1004
- Re: Run-Time Error 1004 Copy method of worksheet class failed
- Selected Cell equals x then..
- Excel 2000 VBA - Set Print Range in dynamic range
- Re: attaching range (from different rows) to combobox
- Re: Force a Number to be Formatted as Text (keep leading 0's)
- variable inside a formula?
- Re: Formatting Number as Text
- Re: Resetting menu option on close...
- To Mark Rosenkrantz
- Formatting Number as Text
- Formatting Number as Text
- Formatting Number as Text
- Excel spreadsheet/template for developing a retail price calculation
- Formatting Number as Text
- Re: Two Questions.
- Re: How? Can i avtivate the buttons
- Re: Control
- Re: OrIf formula needed
- Re: Calling a private sub
- Re: If-Then Formula
- Re: Hi
- Re: OrIf formula needed
- Re: faster than VBA macros
- Re: Run-Time Error 1004
- Re: Combobox Problem
- RE: Run-Time Error 1004
- Re: Inserting rows with a formula
- Re: If-Then Formula
- Re: Looping Through Names
- Re: Combobox Problem
- Re: inserting a row with data
- Re: Adding values in textboxes?
- Re: Looping Through Names
- Re: how to format a date/validate for a text box entry on a user form
- Re: copying cells
- Conditional Formatting comparing multiple values
- Re: How?
- faster than VBA macros
- Re: Macro code question
- chr() for quotation mark
- Re: Conditional Formatting comparing multiple values
- Re: Sheet After Double Click event?
- Re: Inserting text to certain cells
- Re: how to disable listbox change event
- Re: User form search criteria example
- Re: Conditional column selection
- Re: Display values in combo box
- Re: faster than VBA macros
- 1st attempt vba-how do i whatnext in this sub
- Re: Protection Error
- Re: Inputbox to enter date
- Re: Adding values in textboxes...
- Re: Positioning a graphical object
- Re: Adding values in textboxes...
- Macro Names
- Multiple conditional on conditional format formula
- Protection Error
- Re: Multiple conditional on conditional format formula
- Activechart.SetSourceData Source???
- Excel 2000 VBA - Selecting populated range
- Macro Help - check existing tabs
- progress message in status bar
- Worksheet change code
- IsArray on Variant/Object/Range returns true??
- Frustration -- >Filtering a list with the click of a Button
- Error missing file when running macro.
- Placing checkmark beside menu item
- ActiveCell.Address
- Excel 2003 - Showing Userform
- Automate delete macros
- Protecting a sheet with filters
- pulling out info. seperated by a comma
- Sequential Page Numbering
- Changing Excel Object's page setup wthout having a printer installed
- Object Variable question
- Control & Break
- Pocket Excel
- Validation Drop Down
- Default Path for Add-Ins
- VBA-Make Custom Menu Item Fire
- Concatenate function with 200 arguments
- Inputting data on one sheet and automatically updating other sheets
- trouble with a listindex value...
- Getting records from Access 97 to Excel 97
- VB Delete Sheets
- Pivot table giving an error
- TextBox focus 2
- Set range based on cell contents - help required
- Extract MS word data to MS Excel
- Formatting textbox currency on userform
- Sub Menu Items
- Worksheet name
- Workflow OnExpire Event
- Finding and pasting over a row
- matching rows between worksheets/books - best practice
- How to handle other workbook events through personal.xls workbook
- flickering organization chart
- How to use mouse events inside an Excel Sheet ?
- How to create a Macro to Copy Information in one sheet to another sheet.
- Clicking the text in a textbox erases all the data in the box
- Excel Macro - Relative Path
- Copy and paste
- Transpose Dynamic Ranges
- Re: mswinsck.ocx
- Converting Time in a userform
- Locking(?) an excel session
- CheckSpelling + TextBox
- email question
- works on 2000, but not on XP
- It works on 2000, but not on XP
- Re: Copy cells
- GetOpenFilename changes dialog to modless
- How to get the macro record button back
- One on One Training needed in Houston
- passing variables
- MACRO for copying active sheet without using a certain name
- DisplayAlerts Error
- Excel VBA : Coding Problem
- Mail
- Excel Pivot update from Access
- Find column name/number of a value in a row
- Excel trouble
- xlDialogsSendMail
- Assign named ranges
- Combining Macros to make one Macro.
- userform & textboxes
- Excel and Outlook Email
- Macro syntax error when running query
- Define a Dynamic Range Based on an Index
- Customizing commandbar problems
- Open Macro Dialog Box
- Is it memory problem?
- right-click shortcut menu
- help with hide or delete
- Precisely reposition a graphic
- Labels in User-Defined Function Not Working Right (First Problem)
- Macro again...
- Mapland Excel Addin - Programatically Create 1000 distinct maps
- TextBox from Drawing toolbar - 2 questions
- Referencing Listbox on Worksheet
- Splash Screen
- macro prompt to show/hide rows
- Setting variable = to sheet name
- Spin button questions
- help: extracting Execel tables with ADO without reordering them
- Dumb Question
- VLOOKUP for spreadsheet compare
- Up Capture
- If Then
- Visual Basic code help needed
- VB.Net: Create Excel File/App?
- userforms
- Inserting Blank Lines in Selection
- Splash
- Email using CDONTS
- please help...
- Re: Hi Guys...
- Getting Grades
- "Last Saved" information
- Calendar Control issues
- Functions returning multiple answers
- NEED HELP ON FORMULA!
- Excel 4.0 Macro to VBA
- select a range base on Column A
- Keybindings Collection in Excel
- Movement
- parsing complex numbers
- How to tab to a command button?
- Date checking
- WAV Files
- Offset
- Delete a Macro
- Deleting
- error message on combo box
- How to Activate procedure with parameters
- auto fit-wrap texted merged cells
- Help needed...
- macro to create a chart from several worksheets
- Prevent User from saving
- Pivot Table - Sum up Average's in Pivot Table
- VBA Integrated Development Environment basic question
- SQL statement returns zero records
- Excel If Statement ??
- New Menu Name
- inserting a formula with reference to a new sheet in a cell using VBA
- Load and Unload Form commands
- ADODB Recordset problem
- Merging cells must be text format
- Running Powerpoint from Excel
- macro to run a separate macro dependent on value in cell
- Playing music
- Is there an easier way?
- How to use digital certificate in xls file
- Problem Loading Data from SQL to Excel
- on error error
- ruuning part of a macro from another macro
- VBA for opening file/populating combo box with sheet names
- English and American dates...
- saving excel 2003 file in excel 97
- Help on counting occurences
- Hiding columns
- tuning possibilities with checkboxes?
- "LabelColor" an appointment in Outlook with VBA in Excel.
- Does file exist?
- Copy the results of an Access query into an Excel spreadsheet
- Is workbook open?
- Is workbook open?
- MultiSelect Listbox (Forms Toolbar)
- Macro to Insert Rows After a given Text in Col A
- Renaming Sheets automatically
- Maths-Integration
- save file via Marco
- Help with very repetitive task in excel...is there an answer?
- option buttons run Click code when value is changed via VBA code
- templates
- combining cells' data into one cell
- Capturing an Error
- auto type text onclick in a cell
- Sheet Update Help
- Help in calling excel files under portal
- Please help with inserting hyperlink
- Change range name
- search or goto command needed.
- if then elseif on text file imported into excel
- rename sheet automatically
- Change the assigned chart number
- "Pausing" a macro for recalculation
- Locking VBA code via Project properties but cannot save the workbook over itself
- urgent!
- Get Date today from WeekEnding
- Solver: an unexpected internal error occured, ...
- Solver
- Text and TextBox problem
- Artistic Spreadsheet
- Macro
- deleting rows
- code help - onkey
- user defined functions
- "Member not found" exception...Help!
- Paste range of cells on E-maul Msg Body
- Date formatting a file
- Rounding & Formula Bar
- How to format listbox
- Cost Transfer System
- Thank You
- Populating data on userform
- how to protcet my code?
- Add an event / meeting in Outlook via Excel ?
- Modify a conditional format formula in code?
- more than one item Y/N ?
- how to call Access's function in different module in Excel VBA
- Text Box Focus
- urgent-pivot table
- Charting by column name
- inserting a column to the right
- Multiple conditional branching in excel
- Progress Applet
- Changing this code ... Please advise
- Code not rounding
- create a subset range in a VBA UDF
- Loss Deviation
- Thorny Problem
- UDF Help.
- Date local format
- Same workbook, different problem.
- How can I do this
- TextBox - CheckSpelling question
- help with macro
- Code generation
- Sending Mail from within Excel
- changing format
- Help with VBA programing
- Importing a document
- Identify Cell Color Index
- Removing conditional formatting if it exists
- Counting the number of different names in a row
- Getting rid of one side a border?
- Changing a conditional formatting formula?
- Changing a column's number of decimal places
- Sheet number
- Chart - display point details on MouseMove event
- excel missing library
- how to call Access function&module in Excel VBA??
- summ gg
- RE: Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B
- RE: Carriage Return / ALT-Enter in Textbox control
- Date format
- Excel shortcuts in Root Directory out of nowhere
- rename sheet automatically
- GCD & LCM: ANALYSIS TOOLPAK
- Re: Creating a list of directories
- I know selected picture is a shape but typename says is picture
- excel VBA - keypress code
- Progress Bar with Timer
- Slow Array formula or is there any alternative
- PS to PDF Problems
- [/B] Problem: multiple DATA SERIES [/B]
- Populate cells with arrays
- Select a range and copy to new workbook
- Best Way to protect sheet & workbook with VB
- Time formatting
- Canceling SaveAs dialog box without saving workbook
- Macro doesn't perform correctly when using right click menu
- Re: Copying merged cells
- INSERT INTO..SELECT
- LEAP YEAR Validation
- dynamic multipage
- Help!!!! Selecting a cell in another workbook
- How to make the macros work for different Excel versions?
- Excel VBA - Has someone already created this
- Importing with ODBC
- web to variable
- Excel VBA INPUTBOX() - Please Help
- Hiding 0 in Pivot Table
- Re: Copying merged cells?
- if a cell is >0, how do I select a range of cells?
- Increase a range size by X rows and x Columns...
- Creating a log sheet
- concatenate two cells, but with conditions
- hang when formula bar open
- looping through to assign type
- ActiveXTextBox with SpellChecker ?
- Display range values
- Searching multiple files and copying text
- Update Range upon Load
- Cell referencing
- Updating For Loop statements
- Change Formula Name
- which optionbutton is on
- Input VBA
- copy cell to another specific cell
- Macros not working in different versions!
- PivotTable Field Selection
- Excel VBA - Type mismatch during While
- Long autonumber beginning with a 0 (zero)
- Invalid Property Value Error
- VBA - Transferring Information via "If - then"?
- Can we copy a sheet from workbook1 to workbook2 with out open workbook1?
- Re: Identifying Button Clicked
- Date
- RE: VBA macro to join up strings
- Re: Identifying Button Clicked
- Re: VBA macro to join up strings
- Running Unix commands from within Excel VBA
- Re: Timesheet /sum client fifteen minutes intervals activity
- Problem with a macro
- Conditional Mean
- Re: Carriage Return / ALT-Enter in Textbox control
- hiding processes
- Input Box
- Re: Deleting Columns in a range through VBA
- application.run for returning arrays
- Range type variable oddness
- Re: Win32::OLE.pm and Hyperlinks
- Re: Colorindex in a Conditional Format
- Re: Passing Variables
- In Memory Recordset Without Creating Database
- Re: SELECT statement
- Checking if Target is within different ranges
- vba command button
- Textbox restriction
- macro - copy values only
- Finding Last Row
- Searching across all sheets
- VBA retrieving row and column info from user supplied range(s)
- Excel crashes on close - macro related
- Listbox - write newly selected item back to the worksheet
- Can't fix VBA code of workbook - Form
- need to ad one more step to code
- Display data in form from worksheet using Filter
- Efficient User Form vba coding for saving to worksheet
- Hide rows before printing
- Adding to List Box
- Hiding 0 values in Pivot Table
- #VALUE! from OLAP CUBE
- Creating a sortable column
- print userform and setting margin
- Find last real row of filterred data table
- Help with Message Box Please
- Loop cells - get all rows with matching data - paste into different wb
- algorithm to INVERT a multiarea selection ?
- Array Combinations with a Twist
- Re: Returning to original workbook
- validation of input in textbox
- Customizing the tool bar
- Capturing an error and then ignoring it
- opening worksheets
- Option button problem
- ByVal?
- Automatically paste cells that return a value, otherwise maintain existing formula.
- Selecting specific excel charts using VBA
- Setting chart data range automatically
- ListBox Error
- Formatting worksheets
- Help
- VLOOKUP MACRO
- Giving help to the user of my function
- Printing worksheet with printer tray # 3
- Active Sheet
- Excel VBA-Changing cell color with if then function
- Calling (Function?) from Userform_Initialize to generate list of unique values for Combo box
- select date range and copy
- Deleting worksheets
- Count rows in text file by loading into array
- Formatting text with VBA
- How to capture screen through VBA?
- changing nested if statements into a user defined function
- listing sheet tabs
- Excel 2002/2003 Macro Compatibility issue
- Addresses To Columns
- MVP Site
- Creating worksheets with cell values as names
- Converting text files to Excel - a difficult one
- function 's cell caller
- Microsoft Excel Error
- Pop-up box with no 'okay' buttons
- Turn Off Macro Warning
- Pasting Data in VBA
- Enumerated constants defined where?
- How do you delete a row in a macro?
- VBA IDE
- Is there a maximum number of Add-ins allowed? - strange Excel behaviour
- Return Row Heights for Rows in Active Worksheet - an example
- Fill in forms
- Hyperlinks.Delete without losing formatting?
- Re: Slow Code
- Linked DropDown's
- ISNumber VBA
- Re: Splash screen stops Solver add-in working
- Addin installation
- Size Format of Images in Worksheets
- Re: Copy range content as picture - truncation problem
- ActiveX combo box
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.