Have you every used the userforms in VBA?
Start by going to VBA Window and from Insert Menu, select userform. Click
on Userform and select Hammer and Wrench button on toolbar to get the
toolbox. You can add RefEdit to accept text inputs. Can have more than one
Reffedit on the userform.
"ajvasel" wrote:
I am familiar with using cell offset to move the active cell to a
non-specific cell location in VB; however, I am wondering how difficult it
would be to build a user interface that would prompt the user to input the
number of rows/columns to move up/down left/right. I have used user-input
pop-up boxes before but only with a limited number of variables that could be
entered. Any help (or at least a start in the right direction) would be
greatly appreciated. Thanks