It looks like VBA won't recognize RefEdit, because I have other userforms and
different control but no Inputbox.
I can live with the problem, no big deal, but one last try, can we hide the
Cancel button.
Best wishes for the New Year.
John

"joel" wrote in message
...

You can only move controls onto a userform when noi macros are running.
Make sure the runing macros are stopped. Try putting a different
control on the userform to determine if the problem is with the refedit
or some other problem.

You are getting a compiler error becuase VBA doesn't recognize the
Refedit1.


Did you know you can change the default names of the userform and the
controls to any thing you want. From the VBA menu View - Properties.
The select the userform or one of the contols. You can manually change
any of the properties and the property will not change again even if the
workbook is closed. The properties can also be changed using VBA code.

The Name (line 1 of property window) is the property that you would
uses to reference the control from VBA. The caption is the title of the
userform and is also available on some of the controls.

You also may want to put a label (from the toolbox) above the refedit
control to tgive the user instructions on how to use the Userform.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165975

Microsoft Office Help