Posted to microsoft.public.excel.programming

external usenet poster

Posts: 440

Userforms & worksheets

In a textbox on a userform I want to display the next available number from
the worksheet "CD" - column A.
Column A is sequentially numbered so essentially it would be LastRow + 1
I can get the date and time and usernames in other text boxes on the user
form (i.e. UserForm1.TextBox21.Value = UserName()) but I am having trouble
with this number

Any ideas?
--
Traa Dy Liooar

Jock

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
UserForms and double-clicked worksheets...	Dan	Excel Programming	1	March 18th 06 05:35 AM
Userforms	restrepoblessin	Excel Programming	1	September 12th 05 04:26 PM
Userforms	carlito_1985[_4_]	Excel Programming	2	September 12th 05 09:04 AM
userforms / worksheets	Gixxer_J_97[_2_]	Excel Programming	5	March 9th 05 01:25 AM
userforms again...	Jo[_4_]	Excel Programming	3	September 21st 03 12:31 AM

All times are GMT +1. The time now is 07:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us