Userforms

[CJ-22]

I have a userform with serveral buttons that input data into different rows of a spreadsheet. Each button basically adds a number to the next cell in a row. What I want to do now is have the userform display how many numbers are in a specific row (Example - how many numbers are in C3:G3). Is it possible to put a textbox in a userform that counts a range of cells?

Thanks for any help.

[Paul]

If you link your textbox to a cell, for example H1, you can certainly do this. In H1, just type =counta(c1:g1)

Whenever data is entered into any of those cells, the value in the textbox will then change.

[CJ-22]

How do I put the textbox in the userform?

[Paul]

Using the menus: View -->Toolbars --> Control Toolbox, then selecting the Textbox icon. You can then 'draw' your textbox anywhere on the form and then right-click it and choose Properties to set it's LinkedCell attribute.

[CJ-22]

Thanks a bunch pjoaquin. It turned out to be easier than I thought. Your idea worked great.

[Paul]

Thanks, glad I could help.