Hi John
You need to use the Do events statement to update
information on the
userform.
Regards
Graham
-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G PEACH.EASE.LSOFT.COM]
On Behalf Of Spain, John
Sent: 28 November 2006 09:31
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Display Last Record in Excel
Morning everyone, this code lblRecNum.Caption =
CStr(lCurrentRow) places
the cursor in the last row of data but unfortunately it does
not display
the last record information. The Next and Previous buttons
on the user
form work correctly so I can move to the last record in this
way but
this is not the idea.
Also although I can enter dates in the form and use the Add
button to
add them to the spreadsheet they don't show up when I copy
down or open
the form again.
Any suggestions (carefully worded please)
TIA
John R Spain
Asset Management Service
5th Floor
Civic Offices
Guildhall Square
Portsmouth
********
************************************************************
**
This email is for the intended recipient only.
If an addressing, transmission or other error has
misdirected this
email, please notify the author by replying to this email.
If you are not the intended recipient you must not use,
disclose,
distribute, copy or print it.
This email may be monitored, read, recorded and/or retained
by
Portsmouth City Council.
Email monitoring/blocking software may be used.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
------------------------------------------------------------
------------
--
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
This Email and any files transmitted with it are private and
intended solely for the use of the individual or entity to
whom they are addressed and may be confidential, legally
privileged and protected in law. If you have received this
Email in error, please return it to the address it came from
telling them it is not for you and then delete it from your
system. Unauthorised disclosure or copying of the
information in this Email may be unlawful.
Unless stated to the contrary, any opinions expressed in
this message are personal and may not be attributed to Devon
Fire & Rescue Service.
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|