I have a relatively unique need to create a UDF in VB.
I am going to attempt to explain my objective and if anyone has any insight it would be much appreciated.
I need a function that when I click a command button (or shortcut key) the code will start.... first will ask me to input a number value into a text box to be used as a key identifier for a search basically my lookup criteria. Once this is stored to ask me what row I would like to start at to insert in my current worksheet all data rows from another worksheet that match my search criteria. I have had troubles in the past working with input functions in vb.... would anyone have any ideas on how to start this UDF?
Any help would be amazing
Thanks in advance,
I am going to attempt to explain my objective and if anyone has any insight it would be much appreciated.
I need a function that when I click a command button (or shortcut key) the code will start.... first will ask me to input a number value into a text box to be used as a key identifier for a search basically my lookup criteria. Once this is stored to ask me what row I would like to start at to insert in my current worksheet all data rows from another worksheet that match my search criteria. I have had troubles in the past working with input functions in vb.... would anyone have any ideas on how to start this UDF?
Any help would be amazing
Thanks in advance,