Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Entering numeric values

I need some assistance, I have a workbook which will be used for user
entries, these entries are numeric values picked by the user. I am fairly
new to VBA and need advice on how to do the following:

User inputs numeric value into input box and clicks continue

I need the numeric value entered into the next empty cell in a colum and
then by clicking the continue button it initializes another user form which
has the same principles. This needs to be done with eight diffeent user
forms.

Any advice would be helpful


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Entering numeric values

Not sure how the 8 are differentiated, but to get the next free cell, use
something like

Set NextFree = Cells(Rows.Count,"A").End(xlUp).Offset(1,0)
NextFree.Value = myValue

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"M atthew J. Couture" wrote in message
...
I need some assistance, I have a workbook which will be used for user
entries, these entries are numeric values picked by the user. I am fairly
new to VBA and need advice on how to do the following:

User inputs numeric value into input box and clicks continue

I need the numeric value entered into the next empty cell in a colum and
then by clicking the continue button it initializes another user form

which
has the same principles. This needs to be done with eight diffeent user
forms.

Any advice would be helpful




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN ramesh k. goyal - abohar[_2_] Excel Discussion (Misc queries) 1 October 28th 09 06:50 AM
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row Sam via OfficeKB.com Excel Worksheet Functions 5 February 9th 08 03:07 AM
Return Numeric Labels that have different Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 8 December 3rd 06 02:06 AM
entering formula in a numeric array EO Excel Discussion (Misc queries) 0 October 26th 06 03:49 PM
Text values to numeric values jayveejay Excel Discussion (Misc queries) 1 August 10th 05 05:03 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"