| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text boxes which can float outside the Excel application!
from the userform code you can choose
Unload Me or Me.Hide If you want to preserve ant data use the hide method "Robert Crandal" wrote: Wow, thanks soooo much! BTW, which method is used to close out the modeless dialog box?? Is there an unshow() method?? or maybe a hide() method??? I have a pushbutton on my spreadsheet which will be able to toggle the dialog box as visible or hidden(closed). Thank you Rick! "Rick Rothstein" wrote in message ... Add a UserForm (Insert/User Form from the VB editor's menu bar), put your TextBox on it, size the TextBox to suit your needs and then size the UserForm to the TextBox. Display the UserForm from your own code using this command... UserForm1.Show vbModeless where I have assumed the name of the UserForm is UserForm1. -- Rick (MVP - Excel) . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
| Have a text box 'float' over a sheet | Excel Discussion (Misc queries) | |||
| User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
| Setting an array of text boxes equal to individual form text boxes | Excel Programming | |||
| float Text and Combo box | Excel Discussion (Misc queries) | |||
![Patrick Molloy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
