VB code for checking if a field is not null (for locking a row) is needed
I need to automatically lock a field after it's been written into and
has lost focus. Right now I'm using a checkbox, but I want to lock
automatically once the field is dirtied (written into) and it loses
Actually I need to lock a row, but a field is a good start--I can
replicate the code for each field in a row I guess.
What I'm using now; it works, but you manually have to check a
checkbox, and I want to automate this:
If boolcheckbox = True Then
field001.Locked = True
field001.Locked = False
On Dec 24, 8...Creating a drop down like menu for row of cells?
I have a bit of a problem with an excel worksheet that I have going, th
whole sheet is about 450 rows with various bits of input data, an
sub-totals for various sections calculated throughout it.
In order to reduce the size and make it a little bit easier to navigat
through, I am wondering if there is anyway to make rows drop down, lik
say with an arrow to the side that a user can click on to have a grou
of cells drop down, that way I can only have sub totals and su
headings showing. Is this possible to do and how?
I've tired searching through help but can't find anything, and don...gci and -include and -exclude
I am trying get a limited set of files from a directory tree. The following is what i want but it doesn't work. I get
get-childitem -LiteralPath \rm5_0_code_h\source -include *.frm,*.ctl,*.bas,*.cls,*.cs,*.cpp,*.hpp,*.sql,*.java -Recurse
I have even tried to exclude what i don't want but it doesn't seem to matter.
get-childitem -LiteralPath $path -include *.frm,*.ctl,*.bas,*.cls,*.cs,*.cpp,*.hpp,*.sql,*.java -recurse -exclude
i still get them all. what am i doing wrong?
you have to a...allowing rows to break across pages
Operating System: Mac OS X 10.5 (Leopard)
how can i get a row to break across two pages? i can do it in word, and i knew how to do it in excel 04, but i can't figure out how to get it to work in excel 08.
what i'm trying to do is the equivalent of the "allow rows to break across pages" function for tables in word (table&gt;table properties&gt;row). there is no similar function in excel. essentially, what i am trying to do is prevent excel from moving a row to a new page once it reaches a certain length. in other wo...delete rows that have a duplicate id keeping the upper row
I neeed a macro that will delte a row based on a duplicate value in column A;
Row col A col B col C
Claim Number DCC Warranty Code
1 0132482B DTYC 03D
2 0137448A 1
3 0141614A 01D
6 0143504B 1
7 0154120A DW77 01D
9 0159953A DWL0 03D...Datedif exclude weekends
Hello newsgroup gurus and users.
Your kind assistance please.
This question has probably been asked a millions times but
I cant find it.
Does any one have a solution to this.
I want the date difference between two dates but exclude
The NETWORKDAYS function will return the number of days, excluding weekend
and optionally holidays, between two dates. See help for NETWORKDAYS for
more information. This function is part of the Analysis Tool Pack add-in so
you must have that add-in loaded; otherwise, you'll get a #NAME error.
Chip Pe...Timestamp a cell when row is updated.
I am looking for a solution.
My spreadsheet has 5 columns that i do not want this to affect. The 6th
column is "Last Updated".
When i write comments in any cell after H i want it to put the updated date
and time into "Last Updated" in that row.
Another addition to this would be to check the last updated date, if it is
upto 3days from today then turn green, upto 5days yellow and more than 7days
I hope someone can help!
generally this is very easy and the code is below but your question isn't
Is the 'Last updated' colu...Is it possible to record a number with a leading zero in Excel?
I have a number of product codes that have been created with a leading zero
eg 0101 . When they are imported to Excel, Excel removes the leading zero. Is
there a way that I can set Excel up so that it does NOT remove these (kind of
important) digits? I much appreciate your assistance in advance!
Format the cells as Text.
"Jonathan HB" <Jonathan HB@discussions.microsoft.com> wrote in message
> I have a number of product codes that have been created with a leading
> eg 0101 . When th...Format options when format is selected from the top row
...Exclude a cell
Any one know how I can sum all the cell values in a column except the value
of the last cell to be entered which could be say half-way down the column?
Is there a function to exclude a particular cell from "sum" ?
I know a lot of ppl are far more advanced than I am but we all start
Thanks for your help
To exclude cell A16:
Not very elegant, but effcient!
"DF2507" <email@example.com> a �crit dans le message de news:
> Excel 2002
I have data in multiple colums that has been subtotalled by the sum function.
I now wnt to copy and paste or export only the rows containing the subtotals
to a new sheet. When I do this I get all the rows! It does work if I use the
CNTRL key to mark all the individual cells and then paste values only but I
find this a dreadful solution. Surely there is an easier way?
click the 2 in the outline box to hide the data rows
Highlight the range of subtotals
F5>Special>click on visible cells only
> I have data in mul...Selecting row when plus is clicked
I have a form/subform that shows up as a grid of master records with
plusses next to them, and when the plusses are clicked that part of
the grid expands showing a subgrid with detail record.
What I would like is for the selection pointer to move to that record
when the plus expander is clicked.
Is this possible?
...avoiding plotting zero values on graphs
How do I when plotting points of a graph avoid plotting the zero values.
During the start of a new period, there will be several zero values, how can
i aviod excel from plotting these zero values
"Lee" <Lee@discussions.microsoft.com> wrote in message
> How do I when plotting points of a graph avoid plotting the zero
> During the start of a new period, there will be several zero values,
> how can i aviod excel from plotting these zero values
I suggest that, unless the result you ...Pivot Table Zero Value
I've seen many questions on this subject, but none of the solutions seem to
work for me. I have a pivot table that summarizes billing amounts for 20-25
different data items. Also, the rows have two fields. For Example:
Name I.D. Data
John Smith 7756 U.S. Tax Return $800
John Smith 7756 State Tax Return $250
John Smith 7756 Add'l State Return $0
John Doe 8876 U.S. Tax Return ...Row Height
Can anyone help with this.
Is there a piece of code that will change the height of the Row/Rows if
there is data in columns.
If I had data from cells C6 through to C100, only those rows would be 15
instead of the default of 12.75. Because the data is forever changing, I
would want the rows to change with it.
Sounds rather pointless I know, but can it be done
Many thanks in advance
This macro will scan down column C and if the cell is totally empty it will
adjust the height to the default height 12.75, else row height will be 15.
Sub Ro...Excluding zeros
I have stock data in excel which I'd like to chart using
the high low close option. Problem is that the data
contains zeros on some days. Can I get excel to ignore
the zeros instead of plotting them. If not what's the
best way of converting these zeros to blank cells so
that Excel does not chart them.
1) replace zeros (or missing data) by =NA()
2) Tools/Options/Chart and specify what is to be done with missing values.
"Ben" <firstname.lastname@example.org> wrote in message
&...How do you automatically put spaces between rows in a lengthly w.
I have a lengthly work sheet and I want to put spaces between every row--how
do I do that?
Automatically usually involves VBA coding.
Do you really need the inserted rows? Perhaps you could just change the
height of the rows to look double-spaced?
Here is a macro to do the row inserting.
'David McRitchie, misc 2001-06-30
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual 'pre XL97 xlManual
Dim i As Integer
For i = Selection(Selection.Count).Row To Selection(1).Row + 1 Step -1
Rows(i).EntireRow.Inse...Lost Some Row Numbering
Somehow, when I cloned a worksheet to unused worksheet in my
workbook, the numbering (in the left-most column) has lost the 1st 5
values (I failed to copy the 1st 5 rows). IOW, my worksheet starts with
Row 6 and continues down from there. I can't find anything in Google
that tells me how to fix this, so I'm asking here. Please advise. TIA
these lines are probably masked
Le 2012-01-19 17:22, Mike Copeland a �crit :
> Somehow, when I cloned a worksheet to unused worksheet in my
> workbook, the numbering (in the left-most column) has lost the ...How to select full row of List Control when focus is on it.
I am using List Control.How do i select the first sel(Full row)
default,when the focus is on the List Control.The sel is selected when
we click through the mouse.
Please help and guide me
"atul" <email@example.com> skrev i en meddelelse
> I am using List Control.How do i select the first sel(Full row)
> default,when the focus is on the List Control.The sel is selected when
> we click through the mouse.
> Please help and guide me
Something along the lines of
m_ListCtrl.SetE...How to delete rows automatically with values zero out?
I have a spreadsheet with hundreds of rows. Many of them were entered
at the beginning and then were reversed out. I got this spreadsheet
from our ERP system. It is just like this:
Part# Quantity Value
013-001 1 $1.00
013-001 -1 $1.00-
013-002 5 $25.00
013-007 3 $120.00
013-007 -3 $120.00-
022-001 12 $17.00
041-009 7 $251.00
041-009 -7 $251.00-
052-061 10 $30.00
How can I delete those rows autometically with the quantity were zero
out. I don't want them show up on my spr...Is there any *quick* way to view data records *vertically* instead of as horizontal rows?
Ms Access2003 / WindowsXP
Is there any quick way to view data with all fields of a record
arranged vertically (i.e. on top of each other) instead of
Obviously I could copy and paste into msExcell and transpose the whole
However this wont work for really large tables...
"ship" <firstname.lastname@example.org> wrote in message
> Ms Access2003 / WindowsXP
> Is there any quick way to view data with all fields of a record
> arranged v...How do I remove numerous blank rows from Excel spreadsheet?
Data is imported from an external source and contains numerous blank rows
within the data. How can I remove the blank rows without having to select
each one? There are sometimes hundreds of them. Thanks!
highlight the range press F5>click special...>click the radio button
"Blanks">OK Now press ctrl+- and delete rows
> Data is imported from an external source and contains numerous blank rows
> within the data. How can I remove the blank rows without having to select
> each one? There are sometimes hundreds of them. T...leading zeros as a cell format
I have an issue with formating cells. I have a permit number that has
leading zeros sometimes, so I must display them when entered. I have
tried 0?-??????? and 0#-####### but no luck. Heres is what my permit
01-2345678 & 02-8765432.
Format as text.
"Dave" <email@example.com> wrote in message
> Hi All,
> I have an issue with formating cells. I have a permit number that has
> leading zeros sometimes, so I must display them when entered. I have
I'm not understanding conditional formatting re dates.
I have an Excel sheet which has a "Received Date" column. After three days
from the date entered in the "received date" column, I would like the text
for the text for the row to turn orange, after five days I would like the
text for the row to turn red +bold. After 7 days I would like for the rows
in red +bold to show turn yellow and a message box, on document start-up,
to show the user that these rows have overdue tasks that need attention
*now* (basically an irritating nag box)
My first concern is to get the co...excluding repeating values
I have a column wuth date and some entries are repeating. I want to copy that
data to another column, but do not want to copy duplicate values ( I want to
exclude repeating values when copying and pasting). Is there an option to do
Take a look at
In article <CE251167-21F0-470D-9641-508FD96D54FD@microsoft.com>,
"neda5" <firstname.lastname@example.org> wrote:
> I have a column wuth date and some entries are repeating. I want to copy that
> data to another column, but do not want to c...