View Full Version : Excel Help
- hide textbox
- Solved: Delete duplicated, tally to make report
- Invalid forward reference error
- [SOLVED:] Speeding up the processes
- Solved: input data to post in worksheet
- Solved: Two input variables at vlookup
- Problem with Code (Inserting New Row)
- List box from columns?
- Formula -
- Solved: any way to delete & refresh contents in a dropdownbox?
- Problem with .PasteSpecial (xlPasteValues)
- Excel procedure to run Access Query using ADO
- Help: How to make list value change with the source
- UnprotectGreenCells
- How to find the Last Used Row on Each Sheet
- Solved: Change Cell Colors By CF
- Adaptive Database/Table
- Sumif with multiple criteria?s from another worksheet
- Excel Hyperlink
- Highlight cells on combobox selection
- [SOLVED:] Excel data organization nightmare
- Challenging macro
- search data from other worksheet
- Forms/windows or whatever it's called
- Coloring of the tab of a worksheet
- Solved: Copy/paste from all worksheets, except sheet1
- Forcing .xls to open in 2007
- Backgrounf formatting in Text Control
- Solved: Formula - Runtime 1004 Error
- Paste Special Bitmap Excel VBA to Word
- excel formaula
- Solved: VBE column references
- Solved: VBA Combo Box Coding
- Option choices - how do I export results?
- Solved: Procedure Too large to complete message.
- Return named range with vba
- Solved: Hyperlink on menu button
- Can't get a result of formula
- Macro help..
- Sharing: What VBAx Is All About- Give It Up & Smile
- To Compare 2 Sets Of Data And Change The Values Accordingly
- Solved: Value Added Tax conversion problem
- Import Txt and Parse
- Solved: Expiration Date
- Stop User from Entering Formulas
- Cell contents become ###
- Self filling combo boxes
- how to get: Index function keep value?
- Find Range & Fill Down
- Leave out blank items in combobox
- problem with paste to active workbook
- Help: HOw many color is there in Excel
- insert pagebreak if chart is not fully displayed
- SECURING VBA CODE
- import worksheets from changing workbooks name
- code to tell excel which folders to look into.
- stop clock help needed!!!
- Linking Problem
- [SLEEPER:] The "BEST" formula function in Excel:
- Scrollbars for a Frame?
- Check if workbook exists
- How to position a chart?
- Solved: Understanding VBA minutes
- Creating the user GUi forms the right way
- Getting to know what element of ComboBox has been selected
- Store Value of Last Row even after the procedure ends and Excel Closes?
- Listbox Count
- Solved: Pivot Table Formatting
- Help with deleteing row conataining #VALUE!
- Solved: Simple Floating Toolbar - enhancement
- Forms, textboxes & labels
- Excel and Notepad: how avoid additional inverted commas after copy and paste?
- Test if Current Dir is Read Only
- Values and formats of only visible sheets and ranges copied to a new book
- Calling UserForms: FormName.Show or Dim Object/Set New?
- pivot tables and
- Solved: referencing different cells for calculations
- Solved: For Each Loop through Worksheets Collection
- Solved: Passing & Returning array to/from Property Get and Let
- Solved: Range object Id property
- freeze pan
- adding image to vba loaded userform sourced in sheet
- Solved: DisplayFullScreen Question
- users access
- Save a copy solution
- Solved: How to tell if no value is selected in a listbox
- [SOLVED:] How do I force recalulation of custom function on Workbook_Open?
- How to show Form abobe selected cell?
- VBA to grab data from other .XLS file
- Creating a Pivot Table using VBA
- Solved: Adding Sheets By Day Order
- Named Range issue using file online
- MultiPage manipulation
- Solved: Putting String Array to cells directly
- Solved: How to add an Accelerator to a Caption?
- Code for a find sort and copy.
- Weird runtime errors
- Solved: Clear white space off each column of each sheet of a workbook
- Solved: DISPLAY "0" INSTEAD of #NUM!
- Solved: Multidimensional Array
- Presenting two datas in a graph
- Solved: Replace tilde character fails
- Centering Text in a Message Box
- Solved: Formula or vba required for most frequent text in an array.
- Solved: Non-Contiguous Reference Clear Contents
- Creating a graph from a selection
- formatting a label
- dropdown on a form
- Solved: Sorting a Range, Header info?
- Help: Worksheet_change event disable "undo"?
- Solved: For Each Loop Through Sheet Collection Getting Wrong Results
- Random Numbers via HTTP
- Help Adding a constant text to a numeric cell
- [SOLVED:] adding new items to a dropdown
- Collect Data via The Web
- Editable Worksheet_Change result
- Solved: DATA VALIDATION
- Setting the limits in y-dimension for a graph
- Solved: ? Better way to code
- Number of work hours between two dates
- Solved: Highlight Text in TexBox on UserForm Open
- Controls on sheet OTF
- Help: Excel object size unit
- copy paste
- Copy data from excel to another application
- Solved: Sorting on each sheet balks
- Solved: multi summation of columns
- Why does this Crash
- repeating/looping through code
- inputbox variable validation
- Solved: If Instr line of code assistance needed
- Solved: How to move a comment?
- Why can't i select things on non-active sheet?
- Solved: Populate listbox
- To a.Copy/b.Paste or to b.Value=a.Value
- Solved: import multiple text files from listbox
- Collect Data via the Web: redux
- Public variable doesn't reset
- populating lists
- How to clear a userform after completion
- Solved: any way to clear textboxes on a userform?
- Consolidating multipule workbooks
- Declaring a variable and assigning a value to it at once
- Compare and Print with VBA
- Solved: one source two targets, pick with dv
- Solved: Setting Array for Two Sheets- Almost there
- object question
- Solved: Replace Method using variables to find/replace
- Solved: Multiselect listbox
- Solved: Inserting Blank Row
- Solved: update inventory when receiving and shipping
- Solved: Code for buttons
- Solved: How to add image to chart series point
- VBE opens by itself
- Solved: Find last row, Array Worksheets via Function
- Solved: Schedule a macro
- Solved: addTextBox: how to find points from top/left of a specific cell?
- Solved: Reorganizing Data
- find last cell with formula
- Setting up a UserForm
- [SOLVED:] How to Force a Formula to Calculate
- [SLEEPER:] Alternating row colors while sorting???
- Solved: if value less then 5 show warning in worksheet change
- Difference between Sheet and Worksheet
- What object is missin here (error 424)
- Updating graph automatically once the data changes
- Solved: sum visible rows only
- Solved: Rolling average
- Solved: Building add-in errors
- get letter of the active column
- Opening workbooks via shortcuts
- Solved: Layout of Monthly Data needs to change
- Solved: Setting up a global dictionary
- hiding/unhiding a page on a userform
- Lock record creation in Excel
- Solved: Export data to .txt file
- Listbox Multi column error
- Different ways of copying
- Solved: End For Next routine on error
- Forumla Problem
- Method 'Range' of Object_ Worksheet' failed
- Solved: Extended 'ControlTiptext' for combobox items
- Structure of the array that is returned by ClipboardFormats
- Copying from one sheet to another
- check if Access file is open and who the userID is
- [SOLVED:] Sort list Box
- Lock active cell based on value in above cell
- Solved: Place Mult Select Listbox selections in specified cells
- "FIXED OBJECT WILL MOVE" ERROR IN EXCEL
- Solved: Syntax question: Range(....)
- btn click userform add row
- Solved: Getting Hyperlink from cell
- Solved: Method to instruct how many times to do something?
- Solved: Weird workbook on open
- column question
- flashing label
- Setting values for x-axis
- Solved: Connect Combobox to Named Range
- Problem with Excel 2003 XLA (Menu) Add-In
- Listbox problem
- Solved: WorksheetFunction.Vlookup Different Workbook Reference
- Cell swapping
- "Out of memory"
- HTTP: Yahoo Currency Conversion
- Solved: tooltip
- add a numerated worksheet
- Copy and paste macro different worksheets
- must activate sheet before paste?
- advanced graphs - plotting
- Edit Button images
- Solved: Copy multiple Excel Sheets
- Form not working, Cracking me up!
- Using sound in excel 2007
- loading all add-ins at one stroke
- Import Text File to tab in sheet
- Solved: 'Custom' data validation
- Solved: Print Multiple Worksheets Error
- Listbox columns from 2 sheets
- Click on a cell, which one was it?
- date of last backup
- [SOLVED:] Temporarily Remove Conditional Formatting
- Solved: Passing row height properties to array
- Pasting some tables form Excel in Word
- Can I use if, sum, match and offset functions to do this??
- Solved: ScreenUpdating Issue?
- Countif multiple criteria
- [SOLVED:] Getting Data From a Closed Workbook
- Solved: Writing to specific sheets on specific cells
- Solved: CHANGE FROM ALL UPPER CASE
- Workbooks.Open Does not Error if Workbook is not Present
- forms-comboboxes & textboxes
- Still a challenge
- increase numbers by percent in a specific column
- MultiPage -how to change Page color?
- Solved: Sum Across unknown Number of Worksheets
- I don?t want the hide cell to be copying!! How to do it?
- Hide "track changes" option
- I need a menu bar in a userform
- Seek help for value
- Solved: Read string variable while ignoring case sensitiveity
- Solved: Debugging Immediate Window Question
- IF-Then-Else in VBA help needed
- copy sheets and files
- Solved: Find "/" in string & debug.print ?
- Userform Save with contents of TextBoxes
- Closing Excel..
- Help with a while wend loop
- Getting Weekday as String and working with dates
- Freezing two top rows
- Adding text to existing text
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.