[ExcelVBA] RE: Add TextBox Value to a Named Range List

 

Have you tried the activesheet.usedrange.rows.count function?  For example:
>EOList = activesheet.usedrange.rows.count
>cells(EOList+1,1) = x
where x is the value from your user form.

---In excelvba@yahoogroups.com, <smartware.consulting@...> wrote:



Please post your code.

 

Also, what exactly do you mean by "I can't seem to get it to put the new number at the end of the list"?

Regards, Dave S
 

----- Original Message -----

From: sspatriots@...

To: ExcelVBA@yahoogroups.com

Sent: Tuesday, October 22, 2013 10:44 AM

Subject: [ExcelVBA] Add TextBox Value to a Named Range List

I have a Userform that looks at the values in a single column named range list called "PartNoList" and returns the largest number in the list "+ 1". I would like the next step in that code to add that new value to the end of that list. The list is on Sheet4 of my workbook and is named "Part Numbers". I can't seem to get it to put the new number at the end of the list. Any ideas would be greatly appreciated. Thanks, Steve

---

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1432 / Virus Database: 3222/6270 - Release Date: 10/21/13

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___