oskar
New member
- Joined
- May 10, 2013
- Messages
- 24
- Reaction score
- 0
- Points
- 0
- Location
- Montreal, Canada
- Excel Version(s)
- Office 2013
Following a VBA lesson from the web I made a contacts DB and now I have in sheet1 my ActiveX userform and in sheet2 I have my dynamic range DB (a typical address layout with 151 rows).
I would like to but a box in the userform (cmd button, or txtbox or what is appropriate) to indicate the number of used rows in sheet2. In other words this box will tell me the total number of contacts since each row is one contact
I don’t want to press any button to get the number. The number will always be on and change as I add / delete contacts.
This is a hobby project and I have a basic knowledge of VBA (Excel 2013, student)
Thank you
I would like to but a box in the userform (cmd button, or txtbox or what is appropriate) to indicate the number of used rows in sheet2. In other words this box will tell me the total number of contacts since each row is one contact
I don’t want to press any button to get the number. The number will always be on and change as I add / delete contacts.
This is a hobby project and I have a basic knowledge of VBA (Excel 2013, student)
Thank you