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 |
- putting validation to TextBox in the userform
- Textbox problem
- Using Range inputs in functions
- How come my macro works if I pause and play again?
- addins
- How to count rows in a user-defined AutoFilter or AdvancedFilter is active?
- SaveAs without copying Macro
- Need a little help in my macro please
- Coloring a cell with if statement ...
- how to delete unselected columns in a table, thanks
- numers extracting??
- How to catch copy/paste & cut/paste ?
- Creating an Absolute Reference Macro
- Copy only the numbers from cells
- using Sub's with checkboxs
- combo box
- Help with Do Loop
- Applying background color to cells
- Applying background color to cells
- Using selected ranges
- Chronometer in cell
- Set Excel margins from MS Project
- Textbox in Userform not recognised by Module
- excel not installed
- replacing varaibles in formula
- Another Quick Simple VBA question (if...then statement)
- Macro and Edit query help
- skip code
- functions
- avoiding #N/A when using vlookup
- Quick VBA code question (if...then statement)
- stop annoying cell selection change
- Simple VBA Code Question (UserForm)
- nested "with .../end with" statements
- Re: Auto Filter Subtotal
- Filter column using criteria from a userform
- problem selecting entire column
- Ignoring text and spaces ???
- SQL query
- Finding a sum
- Sub to make text bold
- Floor Plan Sketch Add in
- VBA code to
- Outlining Limit
- Macro trouble
- .NET application does not release Excel
- Protect cell
- help!! please with formatting excel to labels
- Re: row archive and auto email
- Commandbutton
- Copy row marco
- Looking for COM Add-In example in VC++
- clearing arrays
- Enable Close button
- List box with multiple selections
- "Invisible" Command Bars Reappear
- Cannot open my files!
- Two VBA/SAP R/3 Questions
- Re: Re: instr isn't finding all the matches
- referencing ComboBox
- DATE = 1ST OF MTH
- putting validation to TextBox in the userform
- SQL.Request from Oracle Database
- get excel to automatically add fill color
- Deleting Rows based on text in cell & formatting cell based on text in column beside it
- Re: Sending Mail using Lotus Notes
- arrays - module to module
- Re: how to set pivotitem.visible property to true
- Row Height
- "Unable to Open File" - excel output of Datagrid <-help needed
- Screen savers
- How to clear a selection
- Detecting whether Caps Lock is set
- Re: Auto Filter Subtotal
- why macro slow first time
- Highlight the entire row of a selected cell
- Text box invisible scroll bars
- Save a copy of Excel in Access???
- Public Variables with UserForms
- Re: Exporting multiple worksheets as CSV
- Fundamental use of Round
- Re: Help Please
- Clear Clipboard in VB
- Re: format cell
- Explain Parameters for a UDF
- How do you change button color by moving over it?
- Customizing toolbar buttons
- Deleting Excel Message/Dialog Boxes
- Disappearing listbox entry
- VBA Problems
- How do you use "except" in a for next loop
- Setting cell background color based on value
- problems with .xml and Excel 2002
- vlookup works sometimes
- AddressOf / Windows API question
- Re: Disable File-Save menu item in macro?
- Tab Between Active X Controls on Worksheet
- Using "Like"
- Problems using VB.Net OleDbDataAdapter and Excel
- help with links needed
- Test for shaded cell?
- how to add search criteria in VBA, EXCEL
- How to get relative range?
- excel addins have reference to wrong file
- Deleting Hidden Files
- How to make a new table based on selected result in listbox
- Multiple excel spreadsheets in one HTML file
- AddIn with Tables
- Re: adding text to end of cell
- Subtotals
- Caps Lock
- What is quicker? Nested or non nested ifs
- Multiple VBAProjects in Excel File
- How to get the RGB values
- Question regarding an activex control button
- computers are not logical
- question about creating a message box
- Re: Code modification to accomodate scaling and print areas.
- Running 2 Excels simultaneously?
- toggling a chart on and off
- help with string functions
- excel vba- userform problem
- Importing Excel data
- Call Private Function from ThisWorkbook module
- Convert
- VBA - How to Write to Specific Worksheets
- Refresh listbox on userform1
- Re:Help with time VBA
- Setting ranges
- range
- Enable Macros
- lenght of a number
- Associating Comboboxes
- Help! Application Error >_<
- "rows" syntax
- Active sheets
- Large scale
- Re: I need a macro to convert my date formats into a custom layout.
- Macro to Autofilter
- Re: I need a macro to convert my date formats into a custom layout.
- Re: Pivot Tables....
- Help with time VBA
- Set Range in one macro to range in another
- using 'enter' on a textbox to activate a command button?
- VB Editor compiles before I finish typing
- Macros for emailing
- Object Library 11.0
- Protecting a macro
- Access control on a worksheet - help!
- Combo Box using Key Input
- Macro help
- Application Security Loses Control
- Excel 97 - Common Dialog Control Help
- looping to End
- Calling an Excel Doc from Internet Explorer
- Re: Can Names refer to Collections?
- Re: Re: instr isn't finding all the matches
- Re: DoCmd.OpenReport problem
- counting cells
- Re: deleting content in cells
- winzip in macro
- Printer error building Excel workbook...?
- format cell based on value
- Identifying blank rows
- adding numbers macro
- Stuck!
- Excel 2000 importing huge ASCII files into different sheets
- Finding blanks in dynamic ranges
- Search based on comparing several values in the same row and column
- How to extract number from cells in excel (function in Excel or VBA?)
- RE: Sum a column
- Re: Sum a column
- Unique ID/Name for a computer?
- Can I use "Unicode" numbers to specify a font?
- Do not copy buttons or macros
- Re: Sum a column
- Re: IndentLevel
- Excel Prg to retreive numeric values
- Symbol font with Times in Data labels
- Time Stamping
- Insert forms created in excel's visual basic into a worksheet or at startup
- Get a cell's name in VBA
- cancel dialogue box automatically in program
- Problem identifying with Checkbox's status
- VBA and comments in Excel2002
- day and date in cells
- Export multiple datagrids on web page to Excel
- best approach? or select last row before page break
- Selecting Contiguous data that contains many empty cells
- new to Excel-have problem
- cell formatted for current day
- TextToColumns
- Run Time error
- Function Calling Subroutine
- EXCEL AND OLEDB
- conditional formating
- ??
- Create Folder / Copy Folder / Replace
- Resizing list boxes in a form
- Macro to Delete Rows
- Re: 'Application.Goto Reference
- Blank lines
- Active cell plus 1
- help on select case
- Protected Sheets suppressing object usage
- Linking...system locking up
- conditional formatting >syntax
- Macro to prevent saving
- Macro & Tool Bar Sharing
- Counter
- ole
- Format and Convert
- Default Value For Functin
- cut & copy line...
- Deleting duplicate entries
- Macro not executed Excel --> PowerPoint
- Macro Sharing
- workbooks.open and appliciation.screenupdating
- Get output Path
- Count rows On error MsgBox
- Selection Failed
- Changing the behavior of the "tab" button
- Select method of Range class failure
- Re: SaveAs Dialog Arguments
- Converting currency
- Create Workbook
- Long Time to Enter Cell Values
- Re-Post: Long and Varying Worksheet Save Times
- Problems ignoring error message
- Textbox & Barcode Scanning
- If a called sub exit, how to the caller exit right away?
- ISNUMBER
- Save as
- Save as
- Changing the Cell Background Color when a keyword is entered
- VBA Editor not showing list of properties & methods
- moving to aparticular view - SOUNDS SIMPLE?!
- variable = current cell in VB
- Protected Worksheets
- pastespecial
- How to perform allocations, planning and budgetting in Excel
- turn on sharing
- How to handle hierarchy processing like this
- Multiple combobox association
- read this
- better search method
- Copying a Worksheet from an AddIn into an empty Workbook
- Automation remote saveing help needed
- Macro to assign a printer to a workbook
- Add add number
- Add add number
- Excel VBA - Executing external programs in an excel macro
- I meant this to be for word, sorry, can you still help me?
- Live link from the Web?
- Copy & SpecialPaste same cell
- Range Resize property
- VB Form to populate spreadsheet.
- Seqentual number save
- Graphic Visualization of an ORACLE data on EXCEL
- Pop-up menu with valid values
- How to select cells?
- application.inputbox
- Excel error when opening a file from ethernet
- Case sensitive sorting in Excel
- Previous Excel Question
- Excel VBA - Exporting values to a txt file
- Creating folders with VB
- GetSaveAsFilename - how to code the arguments
- Import *.asc file into excel fixed width
- Can A Named Range Be A Variable?
- publish excel as web page
- VBA Vlookup External Reference
- How to "Set alias for worksheet in other excel file"
- Printing Diagonal Cells Problem
- Searching for the Odd ‘Fudged’ cell
- Need to search workbook for NEW worksheet
- Replace Function
- Err.Number 1004 with various Err.Descriptions
- help: Activesheet.save error with XL 2000
- Newbie : Sum Cells Part 2
- Getting App.Path in VBA?
- Save date in filename
- Sort column
- lookup, cut, go to named worksheet and paste complete rows
- SmartDocument events
- Finding Non-Blank Cells
- How do I test when a vaule is not found?
- SaveAs another file name, then keep working
- auto copy and past
- cell to textframe using characters object
- Automatically running macros
- Next Cell Question
- CopyAndPaste Object w/namechange
- Conditional formatting formula is evaluated repeatedly
- Question on Positioning Bar Chart Labels
- Wraping text to next line
- restricting fonts
- Forgotten share & protect password
- cond'tnal format 4 date changes
- Entering Dates and auto-completing
- tabular questionable
- reference to Comments
- stop in cell
- Exporting multiple worksheets as CSV
- Open an Acees Form from Excel
- Newbie : How to sum cells via VBA code.
- Filters on with worksheet Protection on in Sharedworkbook
- XL 2002 vba on an XL 2000 machine
- account format in excel
- Catch File>Save/Save As/etc...
- VBA VLookup Reference Problem
- Summing Duplicate Entries in Excel 2000
- SetActivePrinter
- Variable Autofill Range
- Pivot Table Formats in Excel 97
- Saving filename same as import filename
- User Defined Functions
- Re: VBA to prohibit changes to scale setting in page-setup
- Method 'Range" of object'_Global' failed
- validate an option is chosen
- Formula Length
- Error Message in VB
- Multiple worsheets
- Combobox
- How to save each worksheet as seperate file?
- worksheets collection... find...
- Variable Autofill range
- Date Calculation in UserForm TextBox
- Userform text & combobox population help required please
- Application.NetworkTemplatesPath Not Working
- Find the two lowest values and subtract them from a total
- Auto Print
- Assign Formula to Variable
- Calculating the minutes between two times
- Hoping a guru can help this novice out with a simple macro
- Value from Registry
- Set range as multiple columns
- Clear Clipboard on Workbook Close Event (Excel XP)
- Toggle custom button caption
- setup
- Datagrid to Excel - error - rendercontrol
- Paste Function in Macro
- Web Query
- date format ??
- Notify without opening workbook
- Re: Frame Index
- Concatenate and copy in VBA
- Concatenate and copy in VBA
- formula error
- Repeat Multiple Page Headers using VBA
- Using Send Keys to unprotect and protect VB project
- Cell Alignments using a reference worksheet
- ODBC connection for insert into SQL Server
- Dynamic execution of a loop
- Re: Paste text only
- Workbook's BaseTemplate
- Save sheet without links
- Paste text only
- Showing Worksheet Range in Userform
- beginnersproblem copy formulas to cells
- define cell for autofit of merged cells
- Don't want to SEE macro working
- convert number format to time format
- changing values acroos worksheets
- macro won't pull up list's data form
- range: question
- range question
- range question
- Create a help file for VB functions
- Row Height equivalent to xlColumnWidths?
- FormulaArray
- Excel question
- Reformatting of cells on requery of sql source
- Display set area
- Getting data from SQL Server into Excel
- Excel 2002 Workbook Opens Very Slowly
- save photos from a worksheet
- excel application does not shut down after program exit
- Pasting Data into a worksheet
- problem with resize property
- Reference styles and local/non-local formulae - international problems.
- Unselect Filtre ....
- Not sure if this is possible!!
- Keyboard Shortcuts
- random text generator- urgent help
- Analyze timescaled data in excel
- Showing Loop Status
- Search and replace by page break
- referencing values in adjacent cells to selected cell
- Disable Window Right Click
- Problem with comma seperated list
- Referencing a Subprocedures Name
- '$' sign in the form window
- VC7.1++ Excel add-in sample code? Visual Studio 2003
- keep formula after typing in a value in a excel cell
- Edit Textbox using KeyPress vba code in Access
- Combobox
- access a cell by it's name
- Choose file for query
- reading a value from an autoshape 'oval' ?
- checkbox to remove recipient from email
- auto filter
- RE:count time format as decimal
- Do Until Code
- Email - Outlook no Closing Session
- Count by fiil color
- VBA ComboBox
- Use of Templates??
- Creating a Button to add to existing values while subtracting range
- set range question
- funcres.xla
- CopyIntoFirstEmptyRow
- Prevent Access To VBA Editor?
- count time format as decimal
- Run Macro on Worksheet Activate
- Ckear Clipboard
- Office C# code behin : CommandBar Class Problem ?
- Quote in filename causes problem with Application.Run
- Formatting text in a textbox to show separate lines
- Response
- countif with second if?
- Use function in xll in conditional formatting
- If/Then help in returning value
- Disregard last posting
- Max WorksheetFunction
- Changing a Chart on a Protected Sheet
- Tom I Know You Can Do It...
- Dynamic LastCell
- Hiding a toolbar
- C# Excel Automation Add-In
- Format Concatenate Entries
- Maximizing width of graph
- incorrect results when working with doubles or singles
- Subroutine Arguments
- Insert Row and copy formulas
- Pivot Error: Thanks Dick Kusleika
- VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN
- number of rows in spreadsheet
- Printing one or more pages?
- Extra save
- Excel pictures - saving to a file
- vba filter code
- Loop through files
- repeated question: how to protect sheets from within VBA?
- Using user form to change cell value on worksheet
- Distributing secure ('er') Excel workbook
- Nested If(and(...
- Using Data Form
- Scrolling in Multipages
- Listbox questions
- menumaker.xls
- UserForm Events
- Sorting issue
- Selecting cells which do not meet a formatting criteria, and assigning a Range object to these.
- Indicating worksheets are hidden
- Checkbox to remove recipient from bulk email
- Checkbox to remove recipient from email
- Conditional formatting in a cell formula
- Create Add-In
- Close WorkBook with CommandButton
- Speed of SpinButton
- Determined if filtered range is empty
- Import .txt files into XL with time fields-need to calculate
- Can't find project or library
- Selecting a range in a different worksheet
- Q: How to change tab color based on cell value
- Before and After Print macro
- Formatting Number & Text in same cell
- Finding last sheet
- Run macro in another workbook with arguments
- dropping prefix '0's when creating a spreadsheet in code
- Time in combo boxes change to decimals when printing
- Re:backup warranty tracking system
- return row number
- Macro works fine in xl2002 but does not in xl 2000
- date formating help
- numbered labels
- Userfrm Lookup Works For text not Number
- Excel VBA problem
- "Cell"
- Amend a macro by macro
- move content line to column
- Cell Change Event
- Compare worksheets
- Get active cell?
- Remove last characters
- Explain Macro?
- Assign code to button
- Button from Control Box
- Consolidate Data
- (Probably) simple question
- Run macro on certain day and time
- Forcing a macro to (semi-) automatically run
- Broken References
- Problems with referring to workbooks
- Excel 2000 Hanging while reading large file with Line Input
- Floating Toolbar Questions
- Screen Flicker while processing
- Problem when trying to convert one column with multiple rows to one row with multiple column
- File Exists Killing Workbook_Open()
- Is It Possible To Make A Cell Blink..
- Split Function
- 1 Question (no work involved)
- SpecialCells and a Special Character
- Control of Listbox Colors
- Invalid use of Null
- Help with Visual Basic
- TextBox 'ShrinkToFit' oddity ???
- Converting strings to Sum worksheet function and control variables
- Copy formulas, not values
- CONTAINS SPECIFIC TEXT OR NUMBER
- Removing external links in Excel
- Trouble setting variable as filename with date
- Removing "external links" in Excel
- Is there a "Before" Open event?
- JE McGimpsey & Frank Kabel
- Office automation application which will work with any version of office C#.NET
- I have an error when a start my macro
- Web Access Timeout
- Get rows which match selection criteria
- Filter columns in Excel
- Macro doesn't run on another computer
- Transpose
- Auto open macros in Excel
- Macros
- problems with DataForm macro #2
- combobox update
- Timed Tab Rotation in one Workbook
- File Name Exists Error Trap
- Moving a row to new work sheet/book if order=yes
- excel.exe error when adding controls to userforms
- Compare worksheets
- Using sheet codename problems
- user form StartUpPosition
- Variable Reference in R1C1 format
- macro stops midstream
- Datagrid to Excel problem (ASP dot net)
- Chart Series
- Universal Macro
- Getting results from VBA calculations into cells
- Simple Copy & Paste
- Save exact copy of workbook
- STATUS BAR
- Date Calculate
- Importing Data
- Workbook.Variables?
- Add-in functions (some work, some don't)
- Adding a toolbar on a form
- can i link a cell to jump to a worksheet?
- .OnAction with arguments
- Opening all txt files in a folder and saving as excel
- sheet totals
- Query Hangs or Slow Performance after 2 updates
- Recreate a macro menu
- Button Faceid
- Entering data between existing data
- List Files as HyperLink through VBA
- problems with Data Form macro
- Unexpected error (336)?????
- Remove data with listbox
- Calling SUB
- Parsing Text Strings
- Key modifier for double-click event?
- Retrieving external data
- Open File
- File Size Increase Controlled, Question
- event in worksheet switches to VB code window
- For each next choking.
- E-Mail Question
- Delete entire row if A1,2,3... is empty
- Truncating a cell value AFTER the decimal place
- Empty Cell Question.
- Re: Can I reset an array to myarray()
- Excel Instance
- Re: Can I reset an array to myarray()
- Naming Workbooks and Sheets
- copying cells with formulas, but to keep it alike in destination
- Worksheet_Change /ActiveCell.CurrentRegion ?
- activating excel from VB
- xl2002 workbook wont open in xl200
- PivotCache memory resource Problem
- opening a workbook
- Change Excel workbook icon
- vba filter
- how to sign Excel 97 AddIn
- how to protect sheets from VBA?
- Excel VBA/Macro - Textbox
- Selecting & Displaying An Array's Contents
- Excel Web Queries
- Re: Dump of all variable contents
- stepping down rows
- Pivot Table Pain!
- ActiveSheet.PrintOut - problem
- even/odd returns 1 0r 16
- Open dialog in macro
- converting date from a textbox to a date format
- Embedded command button doesn't respond in new window
- Deffinatly need help!!!
- Combo/List Box
- control in user defined function
- Re: Data Validation Prompt Message
- Re: I want to *beep* *beep*!!!!
- Re: I want to *beep* *beep*!!!!
- Excel Chart Event Coding
- Trouble with copy and paste
- For loop question
- FileSystemObject Error
- Close Window
- Can't Group or Ungroup in Protected Cells
- Repost- problem with calender control
- string passing to DLL
- VBA code in "Data" menu
- .additem
- no tab index property in VBA for text fields
- Save file without prompting
- Excel 2000 Protect ... But Free Filter
- Open file in directory
- vba event
- timeformatting and colored cells
- Only allowing one open workbook in excel
- Dynamic GUI
- Problem Reading Delimited File
- Hatched page break lines
- Excel VBA - clock in buttons problem
- Life of a variable
- Looking to subtract one list of values from another
- Pivot table source data question
- New Macro
- How to get rid of a VBAProject?
- Macros assigned to buttons do not work when copied to CD
- on cell entry
- Little task
- Extract data from SAP to Excel?
- Create Object
- Best Solution / Ranges
- Sub Total Method URGENT
- Saving cell content externally.
- Refresh Problem
- How I can compare numbers in one book to another book
- E-mail using Lotus Notes
- Macro - code for ranges urgent!!!
- Combobox update
- Don't update Links
- Counting number of lines in a CELL
- Run a Macro over a Closed Workbook??
- hide and restore personal display settings in excel menu
- Web interaction
- Use ListIndex to set Sheet order?
- ListBox Procedures
- survey for the unemployed
- How do I make Macro Buttons Transparent ?
- Excel VBA Backwards Compatability Problem - 2002->97
- Using VB to auto print documents to pdf files
- FileDialog Folder selection spec
- VBA Code
- back up tracking system while we change software
- Protection
- Command text syntax and comma
- Status Bar
- VBA Code Help
- problem with calender control
- Cell Alignment
- Extract alphabet from string.
- Excel VBA - Delete entire row if all values are 0
- personal.xls...attention Robin????
- Display the Hyperlink Dialog when inserting Hyperlinks
- new to VBA
- VBA InternetExplorer ReadyState loop
- filling
- Problem passing by reference
- Problem importing a txt file
- Renaming worksheets!
- Macro Button To Modify A Cell's Contents?
- Excel.Ink missing
- Working with FedEx electronic invoicing
- dbase
- Send Outlook Attachment within Excel
- Round to numbers in a list
- check for running app
- Disable Button when no workbooks are open.
- ListBox with hidden and visible sheet names?
- How to tell if a range or cell is dirty
- Locking down columns
- Home Made Conditional Functions
- Updating a database query from XL
- limit or deny opening other files
- Log Password Entry Attempts
- Conditional cell lock?
- date of update
- File association to Excel spreadsheet
- converting dates
- SQL Queries in VBA
- Compile error in hidden module error
- Inserting a row
- reading statements
- Combine sheets into one sheet - Urgent
- How do I tell excel to export graphs to ppt and only have to update excel?
- Hide details
- Conditional Formatting between different workbooks (see details..)
- Code writing:Where to start ?
- Web Link - multiple instances
- Type mismatch
- Apply more than one filter in macro/vb code
- RE: Ron Helped Once Can you do it again?
- Import of Database VB app into Excel Spreadsheet
- Is there is a way to tell conditional formatting is on?
- Excel VBA - Delete rows within a date range
- reference missing?
- Re: Excel VBA MID Function
- Public variable is reset after addin macro completes - thread/focus pblm?
- Inputbox
- Re: Excel VBA MID Function
- Re: Excel VBA MID Function
- TIR function
- sheet name as cell : link?
- Re: Excel VBA MID Function
- Export from Excel to Access ADODB
- Re: Find and copy in macro
- Need Quick Fix... Find macro Issue
- Conditionally inserting blank rows using macro
- Copy/Paste
- Show Record Macro Toolbar
- Will setting Saved = True in Workbook_Open have a negative effect?
- Calendar Control
- Pivot table: Adding dynamic columns
- Excel VBA Form problem
- How do I get cursor position and text being typed?
- Sort on two columns in two dimensional array
- serial port data acquisition
- Pivot Table - Page List
- MS Query: Break data into separate sheets based on value?
- Sort row values descending
- Turning Filters ON in a Protected Shared Worksheet
- lookup
- Dim cell AS range....
- Creating a Checkbox inside a cell for each line
- tab order in frame control
- Get NT Username
- Re: Ron Helped Once Can you do it again?
- Odd behavior with SaveAs
- Re: Ron Helped Once Can you do it again?
- pagebreaks
- Copying Data into another worksheet using macro
- ChartCalculate code causing error when saving workbook
- Excel VBA - Check for Duplicate Records
- meaning of Dynamic?
- Active X Support for Excel
- URL too long in Excel (VBA).
- Can't change font on conditional formatting
- Reset New Collection
- Copy method fails in IIS
- Hair Pulling Problem...
- Forcing Events to happen
- Distribute Excel Workbook with licence?
- Anyone can help
- File kill help
- Help with Date checking code
- Database Export to Excel
- Excel VBA Code
- Re:"Insert LineBreak-Macro"Thanks BOB!
- login to worksheet from command button
- help in selecting cells , VBA in Excel
- Need help with an array
- Window;1 doesn't display
- Displaying a specific worksheet on opening application
- Selecting Filtered records only when AutoFilter is on
- save worksheet as new workbook
- Question number Two
- need to disallow pasting into cells directly
- SubTotals
- Applying two or more filters through VB
- curious sheet behaviour
- Difference between NEW and CREATEOBJECT?
- show all rows containing a date between x and y?
- Problem number One
- set a default value on textbox
- How can I control RefreshAll
- UserForm as a Jpeg Image
- Range Names From one sheet to Another
- data transfer automatically in the evening 6:00 P.M
- using autofilter to search 2 columns
- "Path/File Access Error" on Sheets.Copy
- Comment to the Left
- populate chart array
- Execute program (macro?) upon opening a workbook
- Sequential Record ID for Excel Template
- Macro keeps locking up Excel 97
- Macro w/filter, copy, paste,& sort isn't working consistently
- Protecting sheets
- HELP!
- Change colour if cell is locked
- wats the best way for learning Macros, vba's etc
- CopyIntoFirstEmptyRowHorizontally
- How to do a function that alters the format of the cell when it is applied?
- Download from the Web "MACD" Number into Excel
- ASCII Conversion
- Combobox
- Function for optimization
- changing selected label on userform w/ a variable
- Macro to run when file is created from a template
- Printing Worksheets thru VBA
- APR Formula
- Command Button Visibility Problem
- Samples/Tutorials on Excel Statistical functions
- Shifting data down
- Renaming all files in a directory
- Filling selected cells
- Create Excel Document from a Dataset using VB.Net
- row number
- Import Unique Web Data
- Is it to prevent a workbook from being emailed?
- Setting File Attributes and Windows versions
- Form Controls on a worksheet and Macro
- Macro-password
- using array to copy formats as well...
- A Macro to Do Find and Replace
- Multiple Workbooks to a Single Sheet
- Re: Excel VBA - Delete Rows with certain text...
- Reseting A Spreadsheet
- Error trying to set the name of series in a chart.
- Re: Excel VBA - Delete Rows with certain text...
- Adding Header to multicolumn ListBox
- Get Outlook UserProperties
- macro virus
- Insert a row
- AND Headache (with dates)!
- Excel and VB
- Create UTF-8 file
- Macro for Solver
- Pivot Table Group by Month Beforehand
- Inserting rows
- Do I need a two dimensional array for this?
- Sending user selected daa from cmblistbx to sheets of destination
- Long and Varing Worksheet Save Times
- Saving JPEGs Automatically Using Hyperlinks
- color function causes save dialog?
- Need Help With CODE!!!
- ODBC SQL Query give type mismatch in where clause
- Inserting Data: Multiple Sheets
- How Do I Trap #VALUE!
- User Defined Worksheet Functions?
- delete garbage from worksheet
- Visual Basic Macro For Solver
- Visual Basic Compile error in XP
- ReDim to store values so they are not used again
- How can I set PivotItem.Visible property to True?
- Delete characters from a string
- commandbuttn ? in 'ThisWorkBook'
- Still playing with the "Check" macro...
- Changing Cursor in Excel Charts
- Compile error when closing excel
- Column Number/Letter
- Type mismatched in Listbox
- Navigating with a macro
- runtime error ....object required
- why can't i have my VBA XLA post?
- Multiple Workbooks
- autofilter true/false
- Using Filters, Copy and Paste in a macro
- Creating Com object for excel using vb.net
- macros
- Store variable value for Chart
- Looping Macro
- password problem
- Moving one cell over to the right
- Protecting/Unprotecting Workbook
- creating checkbox through form
- How to replace this character ...
- How to avoid error 2015 when using ActiveCell.Offsett in own function
- TOM O , sample is sent
- correspondent in vba...
- Excel97 - Worksheet Protection Question
- VBA - Passing a FUNCTION as an Argument
- Shell to MSAccess
- Shell to MSAccess
- Shell to MSAccess
- Macro or VB to apply filter in spreadsheet
- First Question
- remove toolbar without excel opened
- Problem with optional parameters in Excel Automation Add-in worksheet function
- Hiding Drop Down menu
- Win32 Registry function usage
- Move File When The ...
- Nth Root
- Passing Values From Command Buttons
- A constant update
- Efficient STRING search with SpecialCells
- Delete references
- What type is vbCancel?
- Excel 2000 and 2003
- Popup Menu
- Combboxes and Testboxes
- AddIns.Count
- userform summary
- For Each statement
- Changing cell values between columns with macro
- Sizing row height automatically
- Column Precision Settings
- Application.usermane
- Saving Recordsets
- Returning a string from a function
- Crono with excel
- Problem updating a ComboBox using VBA
- Columns Precision Settings
- control toolbar
- Re: "Insert Line Break-Macro"-Thanks Bob, but..
- xml parser in Excel
- Taking Combobox data...
- Hyperklinks - passing values
- Deselect of Cells
- Checking a cell
- Finding the current date
- 1160 Max Chars per cell ? Workaround ?
- Help with Macro
- A better way to create this function. To long for Data Validation.
- Inserting a Listbox in a cell
- How do I reference the cell address next to Active cell - Try 2
- Error Handling and Cleanup
- Excel programming
- Excel 2003 Activex
- Protect a Cell in an Editable Range
- Path command
- How to ask user for file to open
- Hide/Delete XL Menus
- help with transpose-like macro
- A little more effort...
- Excel VBA - Macro & ShortcutKey Copy
- Making excel macros run Word macros
- Finding and retrieving info
- macro works separately but not together...
- Using DateAdd with a text string
- Find Used area of a range
- Selecting sheet after Userform
- developing an app for the Mac on a w2k box with office 2k
- VB error using EXCEL XP
- CreateEventProc for OLE button crashes Excel
- Array question
- a macro problem with a lot of sheets in a book.
- VB.NET and Excel Range data
- Concatenate with multiple lines in same cell
- Desktop Saving in VB
- For..Next loop problem
- Go To combobox
- How to return to selected cell?
- losing arrays
- User Functions Compilation?
- Excel 97 pivot table VBA problem - why has microsoft built in these random limitations?
- 'Pulling' rows into sheets
- Multiple Col. Selection
- scheduling macros for excel
- Date validation
- Problem incrementing rows
- File formatting!
- complex cell formatting using VBA
- VBA5.dll for Version 6.3
- Find active cell
- Cell Question
- Looping and Filling Info
- Sheet count
- Step through a Word macro called from Excel?
- XL add-in dilemma
- Using a collection class to implement mutliple find/replace strings in cells
- how 2 launch user form ..
- Custom Diaglog Box
- tom oGlivy: Linking data ?
- Web query question.
- Recognizating worksheet name
- Increment row change by two
- Save As Macro
- disabling a command button
- Formula/Text?
- hello :)
- List box data
- Iterating through Cells .Net/Excel 2003
- hyperlink function verification
- Multiple Lookup in VBA
- variables in formulae
- total populate date
- Re: Clearcontents
- NetWorkDays in VBA?
- pausing a macro
- Cycling though all sheets in the workbook
- Easy code!!!!
- If Statement help
- Optimize Slow function
- Excel's VBA <> Word's VBA?
- Make name Generic
- Trying to Open Multiple WorkBooks w/ same beginning FileName
- Can't get parameters on macros working...
- Using the Excel TEXT function within a VBA program
- Determining if two ranges overlap
- Removing Addin Buttons on Toolbars
- Find
- Pivot Table - Hiding Rows
- Help needed with writing a formula
- Filter and copy entire row
- Date Problem
- How to automate a macro to run on all sheets in a workbook
- VBA help screen
- Import .prn file to Excel
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.