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 |
- Help with the following code...from EntireRow to set width
- VBA and PDF files
- Range values not being copied with same number of significant digits
- Auto Mail
- Excel spreadsheeet
- VBA Module Function???
- Linking Worksheets
- Excel Sorting - Finding Duplicate Entries
- Tracking changes in sheets
- NG and Word
- Microsoft Excel Triggers Microsoft Word
- Comparing 2 different work books
- Complex macro issue
- Source Code control vba
- Formatting UserForm Text Field as Numeric
- cell change
- Assign cell to checkbox
- Spin button
- Worksheet event to change formatting when date expires.
- Getting Chart Cursor information in Excel 2003
- Locking Cells
- Getting Chart "Cursor" information in Excel 2003
- Formula to ask what Time/Date it is.
- Property in lowercase
- Getting Chart "Cursor" information j
- SUBTOTAL SUM AND AVERAGE
- Extreme calculations
- Macro not running in Protect Sheet
- Macro not running in Protect Sheet
- How to write VBA code to make backup copy in another folder
- Drawing a Flow Chart / Schematic / (tree diagram?)
- Macro doesnt work from another sheet
- VBScript Event Sink Not Firing
- Dropd Down (validation: list) on the fly with a code - a problem
- Macro / vb query
- VBA time and date?
- Re: Selecting the secon column of a separate range
- Determining number of columns of 2 different ranges
- Appending multiple columns into a new worksheet
- Slow Macro...Takes at least 1 Hour to Run
- exporting to a server
- odd vlookup solution required - can you rise to the challenge?!
- How to change column size in VB6 and Excel 2002
- ActiveWorkbook.SaveAs
- Using MS Query to do a Jion for pivot table data
- Excel List Box
- Re: Vlookup and sheet name
- Combining two ideas?
- Re: Passing frame object in code
- Re: Ranking with Duplicates
- Converstion of Complex Word VBA macro to Excel Macro
- "show office assistant" greyed out; code suspect
- maximizing the size of a UserForm
- Capture Events on programmatically generated Charts
- Deactivate / Reactivate the Paste Function in excel
- Save from exe file to csv file
- I just want to add a W!
- visual basic Loop by rows in Excel
- Changing cell data with macro--HELP!!!!
- Function to call macro
- Offset VLOOKUP data by one row - example in message
- Change background color when value changes in a column.
- RE: replace apostrophe with values above
- RE: Run Macro
- Macro Help ... Pass values to the excel based model and copy + pas
- RE: Run Macro
- Re: Run Macro
- Excel automation issue---enter date into cell based on other cellvalue
- replace apostrophe with values above
- Re: Text format in "Concatenate" function
- Text format in "Concatenate" function
- Run Macro
- Expand the NameBox in Excel 2003
- close all worksheets accept the active one
- Re: Saving an e-mail that attaches a workbook
- Merging cell using VB for Excel
- disable multiple toggle buttons
- format
- format number
- Re: Help with Excel Add-in
- Excel VBA Help
- Re: Help with Excel Add-in
- Re: Addin Issues
- Re: Help with Excel Add-in
- How can I embed a parameter for a stored proc into MS Query?
- Updating Workbook
- Equivalent to vb's causes validation?
- UserForm past data
- Automatic calling of a macro
- ?How to add to a list when sheet is protected?
- Data Fill in VB?
- Re: VBA to set focus back to exel
- count uniques in same column, post in blank cell, repeat until end ofspreadsheet
- Was workbook opened with Excel 2007?
- Placing button at cell's location
- Help with script Please
- Importing text files into a "cached" worksheet?
- Transferring control from macro in one workbook to macro in anothe
- RE: macro probs
- find last row, copy until end
- Returning data from within a date range
- Re: Hiding named ranges before printing
- Re: Check for valid file before hyperlinking
- Dates in macros
- RE: Count Uniques in Column, put result in next blank cell and continu
- macro probs
- Re: Count Uniques in Column, put result in next blank cell andcontinue until last row
- Sorting UsedRange of a Worksheet
- RE: change background color of cell as value changes
- how to count only one instance of an item if multiple occurrences
- Re: RDO working on development PC, not on deployment PC
- Re: Deleting cells in a row
- How to search a cell for last instance of repeating character anddelete to end of data
- Copying from one workbook to multiple workbook
- Creating a fund from stocks
- RE: Error - Method 'CopyFromRecordset' of object 'Range' failed
- RE: Only Copy Subtotals
- Capture/Passing Commandbutton click
- deleting cells: Auto filter or loop or what
- Print to PDF
- Mail Macro
- Advanced copying of range from one workbook to another
- code to merge cells with criteria
- Calling VBA function from a worksheet
- Two criteria
- icon on userform
- Sort by Cells Interior Color Then by Date
- Re: How to generate a text file from Excel using a macro or script
- Edit Function with Keyboard
- Excel 2007 - Split and re-consolidate master workbook
- Deleting rows
- List Box
- Range Formula
- Hidding buttons
- turning hyperlink off
- Form Printing
- Can a macro in excel open SAP
- Import and consolidate multiple files
- Error in Calendar tool - Compile Error
- Deleting cells in a loop
- Pivot table criteria retention
- Hyperlink question (or two)
- Macro VBA code to copy checked items from multiple worksheets
- Connecting userforms to buttons in Excel
- Range Formula
- Hide the #DIV/0! Error
- checking elapsed seconds
- Tool | Reference objects
- Programmatically Possible??
- VBA, VB Script and VB
- HELP: Search a formula inside of a Cell
- Sub to lock vbaproject for viewing for all xls in folder using a common password
- Combining multiple IF statements
- Reading in text file that is more than 65536 rows
- Solver Problem
- Access database error
- Excel & SQL server
- Confusion on Multipage Tabbing
- Code for macro security level
- Excel 2003 - Hide Toolbar
- Solver Macro
- pass a variable to activate
- replace all the cells in sheet that include spsific string-via mac
- Dont want a button
- Convert to Euro - Accounting Format
- Adding watch point "Application.Caller" crashes Edsel 97.
- Input Box - Type mismatch
- Automation of report, daily, monthly then yearly as per need
- Another VBA bug
- Run query to get data from Access based on user input
- Adding a menu item to Excel
- Combining data from column while deleting duplicate rows
- vba with bloomberg links
- linest use in vba
- can,t send any email..get an error message
- hi-lite missing field with macro
- Adding criteria to loop
- Need help automating a pivot table...
- Macro to count files on sharepoint
- Date ranges in macros
- MACRO Help
- new
- Updating text boxes on forms
- Small Help Required
- Macro deletes seperately
- show time of Refresh button execution
- Macro VBA code to copy content from one worksheet to another
- Assigning macro to button
- visual basic editor- defining length of a year
- selecting a range
- Test if Workbook is already open ?
- create folders as I create a row
- accessing data
- delete all the ranges that related to spesific sheet via macro
- excel macro problem
- delete Ranges via macro
- Can not add the page break when converting asp to excel
- Wordpad
- Workbook Slow
- Got Stuck
- Procedure to update a DATE field to either a year from now or a year from what is in the field?
- Find and replace If Then ?
- Serious Macro Menu Help
- Formats not updating with newly pulled data
- Help with code??
- Copying Multipage1 to Multipage2
- Close drop box
- Variable difficulties
- Clearing fields in Userform
- unload or hide?
- unable to get the activate property of the range class
- Wordwrap
- variable doesn't reference correct column
- unique values in an array
- Can you set up custom menus in Excel 2007?
- Add Footer to All Sheets
- linked listboxes
- textbox data to worksheet
- Which project type to use for Excel
- Splitting text in cells.
- Subtracting times
- "embedding" fonts in Excel
- Comparing Lists
- Macro help! Selecting rows after running a filter
- excel and fun?
- inputbox on userform
- Problem in inserting strings and numbers using right to left language
- only load userform if range empty
- Creating directories from given column of data
- Find Cell with Value and get Value of Cell Below it
- Minimize worksheet but keep userform visible
- Change Cell Value and Subtract the cell value in another sheet
- Deleting Code and saving
- Automatically extracting unique values
- Excel 2003 Macro help
- open file in current directory
- MS Query parameter
- Macro for special Insert comment text
- Passing Public Variable into Sheet Sub Functions
- radio buttons to equal values
- Delete row with no data
- Macros do not run when spreadsheet is used on a different computer
- start macro
- using offset with FormulaR1C1
- Excel Macro Selection
- Say "yes" to "OK"
- Remove password from multiple workbooks?
- phantom link/macro
- Opening/Activate Multiple Workbooks - Help
- Excel 2003 hangs on save after creating pivot table
- array
- How do you stop online HELP in 2007
- Programming Min and Max
- Nexted For Statements don't execute fully
- Back Button Macro
- VBA Conditional Formatting to UsedRange on Worksheet
- take every other cell and put in new colume. No blank cells
- Scheduling
- Accessing Form's Values from Invoking Sub
- changing the fill color on a cell
- If And Statements
- Workbooks Array
- Variable file name in copy macro
- For Next Variable Not Being Passed Through For Second Sheet
- Help: Pivot Cache error using Range object containing cell with 255char
- Programatically Add Outline and Grouping with VBA
- Transpose heading array
- Dialog box in a macro
- function question??
- Hide / Unhide Columns in Password Protected w/s
- Dialog Box
- array inside for statement
- Size a Cell to a Picture
- How to deate Conditional statement for the header
- Range End(x1up) problems
- IF statements in Macros
- IF statements in Macros
- Automatically Populate Worksheet Depending on Team Name
- Creating Excel file that points to relative path .cub file
- Rearrange data for printing
- Macro code
- Page break issues
- Keydown Problem
- Enable/Disable Macro
- Sample a random calculated cell
- Pick List
- formula to save value of cell w/o copy- paste special-value
- macro code for XML Fill
- Macro code
- Macro code
- Condensing Task
- Change a range to Uppercase
- Remove _ inside of string
- vb programing match function
- Changing a formula to value only
- import package from
- Two VBA Questions
- auto move cursor
- URG: Saving an e-mail to be digitally signed
- Color Chart
- Formula to add a number
- CustomMenu.Controls.Add
- Open form from another workbook
- ODBC-coupling SQL questions
- CF sheet sub modifications
- Getting the LastRow in ExcelSheet from Word
- String vs LONG format
- how to refer to the files with regular names? (with formula)
- Delete Row and Auto Subtract
- Find row with the same data like in another row
- FindFormat.NumberFormat fails with some strings
- SUM of data from multiple sheets in the mastersheet
- make a data entry into hyperlink using vba?
- Adding new sheets to the right instead of the default left
- Sorting Data in group
- Copying OptionButtons
- vba to append to a text file
- VBA tweak to run faster? <--Rookie here
- Changing the stated output of OptionButtons
- Help for vba to control the PivotItem in specific Field in Pivot Table by choose in inputbox
- Help With VBA Copy Code
- what is the vba language to make hyperlink?
- matching 7 columns of data
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- Delete text in a string marco help
- Size Picture to Cell
- Skipping textbox
- Macro with FOR - IF Loop
- Error with EXCEL macro transfering information to a form in WORD
- Marco that Delete Cells With Specific Text
- VBA to TRIM data <--Rookie here :o)
- Scheduling Macro run
- What am I doing wrong?
- embedded sheets in a Word doc
- Macro and chart help
- Macro handling "Insert comment"
- Send Email from VBA
- How to get the location of a Form Combo Box inside the assigned ma
- references to data sheets
- Training material for VBA for Excel 2007
- InputBox and For...Next Loop
- Date & Time Picker Properties Question
- Can't Undo Macro Command
- VBA: What does Redim Preserve do in term of memory
- Calendar question?
- Move Range with a date to a Matching Monthly Worksheet
- Automate IE to log into bank accounts?
- Excel workbook SaveAs question
- rtd server question
- Finding a floating point value
- Size of Spreadsheet Displayed - both in Cells and TWIPs
- Variables in Query Strings
- Range Question
- Range Question
- Indication that there is a # cell value in the range
- manipulate / perform math on cell location a=a+1
- Extract Whole Row If Q
- Copy-Past as Pictures
- On Got Focus, Clear Cells
- Error handling
- getting new workbook name from opened template
- Worksheet change: move to next cell
- Need macro to trim characters in column
- Identify blanks
- How to backup Excel using VBA?
- EXCEL Spreadsheet CELLS have data but load as NULL
- Managed code error handling from VBA
- Add data from several excel sheets into one
- Clean Up without reducing print window.
- Auto Copy from Sheet1 to Sheet2
- "Compile error in hidden module: Addition" what does it mean?!?!?
- Alter macro security level programmatically
- Macro question
- Microsoft Office Spreadsheet 11.0 Control
- Creating a macro
- Macro to accomplish Zoom and Fit to Simultaneously
- Appreciated!!!
- Accessing Message Editor Of Web Based Email
- Timer
- sending mails from excel...but mail body disappearing
- Create Menu Macro
- Copying cell border formatting, without shading.
- Numeric Value of Choice in Combobox
- count comments funtion
- Macros
- Combining multiple worksheets into a single master sheet
- Select Range
- Judge whether Excel has password without opening it
- LN in UDF
- Naming a range in a module
- UDF is not working
- Conditional formatting
- sorting unknown range
- Transparent button
- fetch the data from sheet2 & place it in sheet1 based on the locat
- What's wrong with this code?
- how to creat shortcut button to switching between worksheets?
- Changing the values of priorities on update
- Microsoft Excel Addin
- repetitive items in For each loop
- Losing certificate details on workbook save
- For..Next error 'End if without block if'
- Pivot table error
- Duplicate sheets by data count
- Application makes VBE crash. How do I troubleshoot?
- Initialization using Multipage Tab
- Send e-mail via macro
- toggle or command and how
- object button name
- Create Pie Chart that changes from one data table with differentyears
- Programmatically changing values on grouped sheets
- Change Formula's to Values
- Compiled Application Crashes
- Floating menu to navigate through worksheets
- Dynamic userform field names
- Slow Procedure
- Checkbox Background Color
- Selecting a Range with a variable in the ordered pair
- Is there a Folder Picker method that shows files too?
- copy a worksheet from a closed file?
- Send attachment via CDO
- Help with search and copy issue
- Worksheet_Change event
- cell select
- Listbox vs Combobox
- move columns to separate worksheets
- If then else, or select case is giving me a problem
- comment copy&past!
- sort from date, to date in list
- Convert Font.Color to System.Drawing.Color in C#
- Range Select
- HOW TO MOVE DATA FROM ONE COLUMN TO MULTI ROW - please help
- RE: User Form Input mask
- Trust Access to Visual Basic Project
- disabling chart export progress bar
- Repeated search on the same worksheet
- How to get Cell.Address from Hyperlink cell
- change the color of a cell as a function of the cell value
- Update created sheet?
- Automatically select correct range
- How to rewrite this code? (Second half)
- How to rewrite this code? (first half)
- help with 3 problems??
- Search for Change in a column.
- Calculate Time
- Dialog to set path
- Initializing Userform not working
- Check error cell in C#
- Formatting with Macros
- File size
- Column Possible
- TRIM Function gives Compiler Error!!!!
- furmula to add hours
- the value of a condition in a conditional format
- VBA question
- Same task for Multiple fields
- AND/OR in Macro
- Move to next cell
- Excel Macro - Extract data from website
- Changing a formula inside a textbox - Excel 2007
- Calling AutoFit using macro in XLCALL.h
- Extract rows to different sheets
- Save several worksheets into one file
- Merging
- Error Number: 91 object variable or With block Variable not set
- Running a macro from the spreadsheet
- C++ Excel Automation
- Run Macro from different files
- how to set pivotitem.visible property to true
- Selecting A Tab By Its Name
- Command button
- Consolidating Various Excel Files
- Sort WorkSheetName unknown
- Listboxes
- Conditional Formating
- vb code to re-arrange data
- 2 line headers in excel 2003 spreadsheets
- Convert NumberFormat to System.Type
- Toolbars GONE!
- Specifying Cells To Copy Across Workbooks Not Working!
- Ribbon Image Size
- Missing relative reference icon
- Use Contents of a Cell to Create a Hyperlink
- Function instead of "Text to Column"
- auto start code when a sheet is looked at
- Deleting CommandBar("").Controls
- Page Header Macro?
- Single Row Count
- set print area to last occupied row
- Another lookup question
- Common Dialog Control Reference problem
- set print area to last occupied row
- Transposing/combining columns with 2 headers
- Pasting and organizing information from one sheet to another
- transpose address information for each customer number
- Data Validation Pop-downs
- Loop help Please
- Excel General Ledger Template
- html exported to excel when save as, defaults to web page
- RANGE
- Re: excel multiple choice toggles
- how can i automate copying of tabs to a new workbook?
- user form and radio buttons
- Find and Replace Macro
- Calling AutoFit using C API's
- Last Real Cell
- VBA ReadyState basics
- ie Command to Wait for "File Download" and "Save As" windows
- Merge problem
- Updating Date Field in Pivot Table with VBA Help
- IF and ISBlank for a selected range of cells
- getting error message 3704 when running excel vba
- Macro on Current Row
- How to save a project independent of a spreadsheet
- Displaying Line #'s
- Using VBA: Conditional Formatting of Row Color
- Formatting a worksheet
- locad password protected MS Access table
- Highlighting Rows and Columns with Macro and VB
- Column List to Multiple Columns
- Change sheets within a read and write function...
- Slow tabstrip
- Column AutoFit C API
- Find next empty row & paste data
- FitToPagesWide
- ListView - ItemClick - How to know column number
- Macro to Edit Contents of Cell
- Time Calculation w/ Macro
- Export records into a text file based on criteria
- Creating a list box
- Get numbers from cell
- load list data
- ByRef argument type mismatch when passing dictionary object
- Vlookup to Return Cell Name Not Value?
- do loop until empty cell
- Overwrite conditional formatting
- Problem with IE
- Disable Ctrl- PAGEUP PAGEDWN
- Find value in sheet 1 and copy matching row from sheet 2
- Auto insert
- Version Issues
- How do you x-late GetTextExtentPoint32's units into the real world?
- Can Search's default be changed to "By Columns"?
- nested for each or something else??
- Excel Add & Substract in One Cell
- Check for incorrect characters
- Extract Access records to new workbook using VBA in Excel
- Extensive file damage.
- Add data range to a specific tab based on "Sheet Name"
- Tabstrip Tabs Width
- Excel VBA functionality and SharePoint
- Trust Access to Visual Basic Project - Access to Excel and back
- Disabling SAVE AS Temporarily
- Sub to delete only all damaged defined ranges in book
- advanced lookup feature
- vba structure
- Conditionally format cells
- How do you hide .....
- Copy variable to clipboard
- exception in excel while writting to it
- reset a cell
- Re: Splitting up timeperiod
- Re: How to generate a text file from Excel using a macro or script
- Listbox help
- finding UsedRange with sparse data
- Outlook VB not working
- I protect sheet - Macro will not run now
- Excel 2007 ListBox missing last item
- Userform - 100 checkbox (10X10)
- Select Object Button
- stock the header items of a .dbf file into a vector
- Is 'IgnoreRemoteRequests' the same as....
- Making a [semi] Dictator Application: Hiding Main Command Bar?
- Sum variable ranges
- VBA...No Subroutine Code
- newbie - If a cell is blank
- Printing worksheets
- identifying multi-select items in a listbox
- Dynamically Change Cell Contents From VB
- Change Axis Title
- AutoFit function
- "next and "previous"button problem in vba
- Automatic Calculating & Autofil in Various Tabs
- loading another application from excel vba
- Count positive value
- import xml in excel workbok using VBA code
- Spreadsheet Component
- break apart pdf binder
- Blank cells & formula cells
- VBA to move and concatenate
- VBA to Update Pivot Table
- Importing Access to Excel
- data entry
- help with Run-time error '1004'
- Target.Cells.Count
- Target.
- Bypassing the Security Warning when opening Excel file
- Font enlarge/reduce by 1 pt?
- Trouble with code that is broken over multiple lines (space_)
- Modify the IgnoreBlank property of the Validation object
- Difference between two dates
- Does a shape cover a cell ?
- Macro to Paste Unformatted Text Into Excel
- hard time with If InStr(1, ..
- clear contents on linked sheet
- Combo box the exludes blanks
- working with images
- How can i automate the response to a generated pop up?
- Re: How to generate a text file from Excel using a macro or script
- Parameter Driven Query
- Lots of similar buttons need to call a macro but need to find outwhich button was clicked
- read xml and fill valuesin excel form combobox
- Re: Password Protecting/Unprotecting Worksheets using VBA code?
- Checking worksheet names
- Creating different worksheets from a main worksheet
- Clear entire rows below last row of data in col A except in 1st 3 sheets
- Loop Till the end of used Cell
- option button problem
- Why doesn't the FindNext work inside a function ?
- Re: Returning column letter
- Forcing Move seelction to the right
- Re: Returning column letter
- Filldown top cell to last row with data in adjacent col
- How can I see the Project Explorer and Code window together?
- Synchronizing worksheets
- How to validate path? --- bValidatePath ("") Then
- Activate one Book then another Book
- Problems adjusting column width
- How to change the background colour on event?
- Excel VBA : Find Method
- Change rangre color with scroll bar
- How do I select an option button using code
- Rename active sheet
- Read text into Excel
- Repost of How to get Popup Text help to work
- Hot to Get a Column Number from a column letter
- hyperlink in Excel 2003
- error running macro from Ribbon button
- CONCATENATE preserving original formating
- How can I list values in a combo box?
- Series order vs Legend Order in Charts
- I NEED AN EXCEL TEMPLATE FOR ANNUAL BUDGET CONTROL OF SMALL BUSIN
- Worksheet Help
- Custom View: hide/unhide does not work when worksheet is protected
- Change UserForm font
- Enable Auto Refresh Message Box
- Turn AutoCalc before calc takes place
- Adding help to a user defined function
- read datas from XML to excel using VBAmacros
- 2008 federal payroll withholding tax
- incrementing a cell value
- Choosing no when asked to overwrite an existing file?
- check box help!
- creating hyperlink using the value of the cell
- Make active cell a variable, return there later
- CreateObject from Template
- Formula for Finding Retail
- Select first 5 visible rows
- Can I find out if & where "Freeze Panes" is set
- VBA function wont update in worksheet
- Select charts by "Chart Names"
- Change Event
- annunce: excelmailer 0.2
- ctrl-a
- excel temp file
- Exclude gray figures from sum
- TextBox mismatch ..... calculation
- Copy cell to empty cells below.
- Protects running from VBA, but not from hot key
- Hou would you optimize this code?
- writing screens to enter data
- How to find a matching row and Insert Data
- Insert Multiple rows with data
- About xml constructing
- how do i create a macro that will print and save my file to sharep
- How2 accept only numbers in userform textbox
- HELP!!
- Need user unable to unhide sheets
- User Defined Record Compile Error
- Disable auto-update
- Date Range Macro
- Populate Comment on the basis of Text Box Entry
- 2007 Ribbon dropdown
- Duplicate items in ComboBox
- merging cells using VB - Excel 2003
- How do I Create a Macro to run VB Code in Excel?
- Excel and Calendars
- Change text in Textbox on Chart?
- protected linked cell
- Macro problems: Waiting for site to load and commanding Save todownload prompt
- MACRO IS NOT COMPLETE
- Spread data and keep format
- checkbox
- Using VBA to send email to distribution list ... how to CC?
- name box
- programatically create new worksheet
- Apply code to Icon
- Find first blank cell
- use a range variable in advanced filter
- Last Empty Row in Range
- "Move or Copy" sheet
- Variable not Defined Compile error
- Selecting multiple areas
- Sheet Protection doesn't hold
- Shapes!
- Columns ranked by highest revenue
- Repost: Copy Range from one wbk to another
- Popup box appears based on cell value entered
- Copy range from one workbook to another
- Uninstall Add-ins when workbook closes
- Unhide Worksheet with Login UserForm
- Row Headings (cell number) on Rightside
- VBA multiple events
- Hide/Show Rows based on Cell Value with Data Validation
- Activate woorkbook
- reset pivot table name
- First blank cell
- Who last opened file?
- Iteration Error
- NEED ADDITION IN MACRO
- VBA to save a chart as a GIF
- Bug applying Borders to Range
- Input Box code help
- Help in vba
- How I can get color (RGB value) from .ThemeColor + .TintAndShade?
- Worksheet with some limits
- How do I set a range to the currently selected cells?
- label to display multi rows and colums on a userform
- How to Refer to Another Excel Workbook
- Protected VBA vs RibbonX question
- How to get Popup Text help to work
- min function trouble
- How to enter a formula over 250 characters?
- Trying to create dropdowns in excel using vb.net
- What is the VBA function to return the greater of two integers?
- Value transfered to cell differs from value in record set
- Keep Losing VBAProject
- Amend sub to re-hide comment when activecell change to another
- Code not working since upgrade to 2007
- Application Maximise event
- HELP - Vlookup with referenced tab name
- Help with an IF Formula
- If B1=Level 1 then B2=10
- If b1 = 1, then b2 = Yellow
- Formlua Entry
- Using ADO to import Access table
- Conditional formatting cells with formulas = "DIV/0!"
- using the calendar on a userform
- Advanced transposing in Excel
- countif formula
- surpress leading and trail spaces
- Finding max value
- Loop Through Combo Boxes on Worksheet and in Workbook
- PT - list multiple page field selections
- exit sub if no data
- Usage of StockQuote.MSNStockQuote in excel vba code
- How to show zero values in conditional sums
- Add code on the fly to existing userforms
- writing to a table in wrod from excel
- PRINTING PAGES !
- Select or Enter into a TextBox on a UserForm
- Date format text conversion
- Linking to specific pages in a PDF
- removing comma in data string
- Help with code: Web query for security agreement
- Error for loop
- outlook and excel
- exit for loop
- copy access table in to cells comments
- Linking from a Combo box to another excel file's specific workshee
- userform
- Get parameters to create existing chart
- How do you do this?
- Creating Lookup User Form
- On Error GoTo .... error
- command button code needed
- Trouble changing Range destination
- Print Range
- Retrieving hyperlink from cell
- macro for mail merge automation
- ThisWorkbook.VBProject.References
- Excel Help
- Hover-over Function
- AllowEditRanges
- Attn: Barb Reinhardt
- VBA Tutorial problem
- Build DateSeries (?)
- ThisChart function similar to ThisWorkbook (XL2003)
- Excel and COM
- Updating tables in Access
- Document Manager Toolbar
- User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation?
- Excerise with Days Off
- Formula problem
- Please help...
- =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
- ChangePivotCache
- dynamic print ranges ...
- Ping via VBA
- script to increase last number in cell entry for hyperlink
- Lookup variabel field in variabel sheet
- Copy paste different columns (ranges) to word
- Unable to disable macro
- Scalar Multiplying VBA Array
- userform and inputboxes
- Sheet sub to centralize comment display on mouse over
- Multi-threading in VBA
- Displays numbers as $ on a form
- auto filter based on color
- hiding excel
- Pivot Table Pivot Item Visible - Why so difficult
- find the matching and supply the quantity
- find the item and supply the required quantity
- Apply a macro to only one sheet
- cell list from access table
- adv: Designing reports in Excel
- Upon error close workbook
- Changed variable value
- multiple text files to multiple rows in excel
- Finding exact date
- using excel data to create multiple web pages
- Basic combobox question re setting values
- centering checkboxes vertical in cell
- Macro Looping Problem
- Loop or If then Question.
- Highlight text in Textbox
- Error data mismatch ??
- Problem with Public Variable value being changed.
- Vlookup Error
- Copy from 1 worksheet to multipule worksheets based upon worksheetname
- run access macro from excel pass parameter
- Total beginner
- Pausing Code
- Extract string from cells
- Insert Matched Value
- Data input and database record using macro's
- how to hve input box on msgbox
- copying formulae down a column
- Programmatically Open Locked VBAProject
- Area of freeform shapes
- Problem with Userform
- Shift-tab in keydown event
- Formula to count Month in Dates
- excel dates in sql procedures
- How to simulate Control (button) and Mouse Selection of cell
- How to count items depending on attributes in VBA
- How to print data in a text box
- out of range message
- automatically copy information to different sheet if certain condi
- Resize msgbox windows
- interactive message with mouse selection
- import access table to excel spreadsheet
- Weekly Totals
- Value between 2 values
- Item Count
- msg box 2 add and see data
- find the matching and allocate the required quantity
- M I.5 Persecuti on , why the s ecurity s ervices?
- sort using forms button - cycle thru 9 columns
- Code assistance
- Userforms Won't Close
- Can't Adjust the Screen Image
- Running an Excel AddIn from Access in Current WorkBook....Help!!!!
- Trimming Characters
- About Naming MSForm in VBE.
- Data Update Loops between Folders
- Stop Save as code
- Transfer flat file to a Shared folder.
- Update sheetname from cell, automatically
- Subtotal macro and delete original data
- Prevent duplicates in ListBox
- List files in Folder if Condition is Met
- UserForm not displaying
- Expert in Macro
- BLINK CELL COLOUR OR TEXT BY CONDITIONAL FORMATTING
- Disable custom menu item based on visible cells
- Help files
- Mandatory Cell check on multy page workbook
- Textbox for accepting TIME
- M I.5 Persecutio n ' abus e in set- up situati ons an d in publi c
- M,I-5,Per secution Ber nard Lev in expres ses h is views
- How Excel VBA corporate with MSN Alerts?
- M I.5 Persecutio n , Be rnard Le vin exp resses h is vie ws
- M I-5,Persecut ion c ost of t he operati on
- Sheet name, creating dynamically to be used in formula....
- M I`5,P ersecution , C apital Rad io - Chr is Ta rrant
- M,I`5 Persecu tion bu gging a nd counter-surveillanc e
- Link the ListCount to a Label automatically.
- Quick text key to format 2 cells
- msg box to display specials
- pop up msg box
- sub to delete all sheets other than x, y, z
- How to get back values in the excel bulidin dialogs ?
- Automated Forms issue
- PowerPoint export to Excel
- Protecting sheet in a macro doesn't work
- Data Link
- repeating formulas
- rows
- Pulling cell value into macro
- Showing large image in Excel ribbon UI
- Copy and Paste down the column
- Type Mismatch Help
- embedded Excel sheets in Word documents
- Linked Data Validation(s)
- Need help with Macro
- Unloading /Closing all userforms
- Convert Columns to Rows based upon a duplicate value
- Array formula acting as it shuld ... but
- Data Validation and a Clear Button
- COMBINE TWO MACROS INTO ONE
- Named Range Formula
- Searching online behind the scenes
- Ignore breakpoint when running a macro
- Specifying Row to Copy Across ?
- .formula property bug?
- HOW TO MIX TWO MACRO CODES
- Insert Date in correct cell
- toggle borders
- listbox remove item according to the value
- Run macro when file closes
- active sheet is 'slow' to be active
- dilemma with getting sql data
- Workable Scatter Plot Data Points
- grid on user form
- Split ActiveCell.Value and delete element if.........
- Dynamic Range
- Where to put code
- "UpdateLinks = 3" not working?
- can't select worksheet
- How to evaluate string form of numeric expression in VBA?
- assign macro to button programmatically
- Enable Excel Speech
- Problems with autofiltering and dates I think
- Don't want backup copy in XLSTART
- Endless Loop - Shortcut Key To Stop Code?
- Drop List
- Text Box Change Event
- recalling named ranges as must fill cell
- how to connect pictures from an excel sheet to a power point slide
- Drag-n-Drop_XLA_Install (VB Script)
- Drawing across Data from different workbook using long list.
- Importing Data - 2
- Importing data
- xl probs.
- Zoom to fit the page width
- check criteria and run macro
- go and check on spesific page and then run macro
- protect sheet with password
- Can not access MS Visual Basic Documentation
- Changing font color based on positive or negative number
- Formula / Football Pool / HELP
- Football Pool Fun HELP
- Match function in VBA
- color number list????
- Automated Build -- auto import of .BAS module into XLS or XLT?
- Having difficulty with scroll bar in VB
- code to choose tab color?
- IF Condition in Excel
- Function To Combine two 3-D arrays
- how to make a function(vb script) global (as in used from every w.
- Cell formating
- Opening explorer using VB
- Macros in Formulas
- Speed the macro works
- Updating time made by macro in excel
- Excel Form HELP
- how do I add vba reference to Microsoft Forms 2.0 Object Library?
- For Each Ctl In Me.Controls
- Userform - need to access data from a particular sheet
- small easy userform
- if then else
- delete rows
- Alternatives to "WorksheetFunction.VLookup"
- Hiding rows with zero values
- automating import of several text files from specified folder
- excel macro in '97 does not work in Vista
- Need help with userform vb code, any help would be appreciated.
- Add help or help file to a user defined function?
- Macro to insert at correct point
- vb add-in manager is empty
- solve for a variable
- Help with find/replace
- Format sheet programmaticlly??
- Help for VBA Functions
- Macro Path
- Search worksheet from add-in
- Change Text size on focus
- how to format a date to be used in sqlstring in excel 2007- contd
- Pivot Table Macro
- Deletions
- Shapes(Count)
- Search code help needed??
- Center Checkbox
- Macro Path
- Need Text box value to be $5,000.00 not 5000
- Code to copy cell borders and fill color from one cell to another
- SpecialCells(Formula) --> Value
- Dynamic data in PivotSelect statement
- Copy date from row 1 to last row next sheet
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.