ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   user difined inputbox (https://www.excelbanter.com/excel-programming/348201-user-difined-inputbox.html)

Brian Matlack[_36_]

user difined inputbox
 

Hi!
Could someone show me what the code would look like to create and
display a form that the user would enter an alphnumeric string and then
select OK or Cancel and the string would be placed somwhere in the
workbook or the macro would be canceled.
Or possibly there is a collection of examples somewhere I could
download?
Thanks!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=493786


Dave Peterson

user difined inputbox
 
Debra Dalgleish could!

http://contextures.com/xlUserForm01.html



Brian Matlack wrote:

Hi!
Could someone show me what the code would look like to create and
display a form that the user would enter an alphnumeric string and then
select OK or Cancel and the string would be placed somwhere in the
workbook or the macro would be canceled.
Or possibly there is a collection of examples somewhere I could
download?
Thanks!

--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=493786


--

Dave Peterson

Brian Matlack[_37_]

user difined inputbox
 

Dave Peterson Wrote:
Debra Dalgleish could!

http://contextures.com/xlUserForm01.html



Brian Matlack wrote:

Hi!
Could someone show me what the code would look like to create and
display a form that the user would enter an alphnumeric string and

then
select OK or Cancel and the string would be placed somwhere in the
workbook or the macro would be canceled.
Or possibly there is a collection of examples somewhere I could
download?
Thanks!

--
Brian Matlack

------------------------------------------------------------------------
Brian Matlack's Profile:

http://www.excelforum.com/member.php...fo&userid=3508
View this thread:

http://www.excelforum.com/showthread...hreadid=493786

--

Dave Peterson

Great Help Dave Thanks


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=493786



All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com