I want to know if I create an Excel User Form through the Visual Basic
Editor, but I don't have Visual Basic install on my PC. Can I still do it and
目前分類:title (3013)
- Oct 22 Sun 2006 20:10
Can I create an Excel User Form without VB install on my PC?
- Oct 22 Sun 2006 20:10
is there an autocomplete for numbers in excel?
I am preparing a lengthy list which inlvoves social scurity numbers and would
like to know if I have typed in a duplicate without doing a search each and
- Oct 22 Sun 2006 20:10
Custom format rounding
How can I display 123,432,000 as 123,400 using custom formats? What I need is
rounding to the nearest 100,000.
- Oct 22 Sun 2006 20:10
File Extension (.xls) In Header
Hello,
- Oct 22 Sun 2006 20:10
Lots of numbers and columns
Column A has several hundred fixed numbers. Columns B-infinity contains some
of the numbers in column A. I want to sort colums B-infinity so the rows
- Oct 22 Sun 2006 20:10
How do I do a Reverse Find/Search in Excel?
I am trying to parse addresses into their basic components (I.E. quot;123 Main
Streetquot; becomes quot;123quot;, quot;Mainquot;, quot;Streetquot;) in an Excel Spreadsheet, for later
- Oct 22 Sun 2006 20:10
create a list box in one cell of state abbreviations
How do I create a list box within a cell of state abbreviations which i can
then use as a lookup reference for a formula applying tax rates.
- Oct 22 Sun 2006 20:10
I want to relocate a column, save the figures, and erase formula
I have a worksheet with several columns on it. At the end is a total column.
The formula adds all the numbers across to make the total. I want to move
- Oct 22 Sun 2006 20:10
Moving Average projection?
- Oct 22 Sun 2006 20:10
change sheet name macro
I have a large spreadsheet and I am trying to add a macro that allows me to
add a worksheet AND have an input box pop up so I can name the worksheet
- Oct 22 Sun 2006 20:10
How to transfer a sum from one spredsheet to another
I have a list of various food in Sheet!1 A, and the calories are listed in
colomn B in Sheet!1.
- Oct 22 Sun 2006 20:10
Expand/Collapse Rows
Hi, I am writing a macro to expand/collapse a group of rows.
- Oct 22 Sun 2006 20:10
VLOOKUP works in some cells but not others.
Excel 2000
- Oct 22 Sun 2006 20:10
VLOOKUP in large Data sets of more than 16384 rows
I have a problem with VLOOKUP looking in sorted lists of more than 16384 items.
Basically it fails at 16385th item
- Oct 22 Sun 2006 20:10
How do you reset the quot;Protectionquot; in a file?
My file won't allow me to quot;conditional formatquot; or run quot;protectionquot; anymore.
I did have a password on it and that option is gray as well. How can I
- Oct 22 Sun 2006 20:10
problems opening files in XLSTART
I am having problems getting all the files in the XLSTART folder to open up
with Excel. It used to open up all three that I have in there, but now it
- Oct 22 Sun 2006 20:10
calendar template
I am looking for a template for the 2006-2007 academic year
- Oct 22 Sun 2006 20:10
Compare date against multiple dates
I have a date (say current month) and I want to check to see if that date is
before, after or in the same month as other dates found in other cells.
- Oct 22 Sun 2006 20:10
calculation formulas
- Oct 22 Sun 2006 20:10
How can I lock worksheets while macros can still enter into them?
I want to lock worksheets for outside users. But when I do it and a macro
needs to go into the worksheet, the system gives an error. So is there a way