VBA code that counts the number of entries in a textbox from a different sheet?

**danbates** · 01-23-2018, 05:56 AM

Hi,

Please can someone help me?

Is it possible to have a textbox on say worksheet 'A' that counts the number of entries on worksheet 'B'?

So basically if the operator entered 10 entries on worksheet 'B' then the textbox on worksheet 'A' would have a 10 showing in it.

Any help would be much appreciated.

Regards

Dan

**TMS** · 01-23-2018, 06:05 AM

Not really. The clue's in the name ... TextBox.

You could maybe use a Worksheet Change Event handler on worksheet B that monitors the entries and updates the TextBox.

VBA code that counts the number of entries in a textbox from a different sheet?

LinkBack

Thread Tools

Rate This Thread

Display

VBA code that counts the number of entries in a textbox from a different sheet?

Re: VBA code that counts the number of entries in a textbox from a different sheet?

Thread Information

Users Browsing this Thread

Similar Threads

Macro which counts the number of cells in sheet 1& in sheet 2 this exact number is pasted

[SOLVED] Code that Counts number of time string occurs in a column

I need a formula the counts the number of cells that meet 2 conditions ac multiple w/sheet

[SOLVED] How do I write a vba code which counts a number of loops?

[SOLVED] How to create a function that counts horizontal entries

run different code upon the number assigned in textbox

Move userform TextBox entries to cells on a sheet

Bookmarks

Bookmarks

Posting Permissions