Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text boxes which can float outside the Excel application!
My users typically have multiple different applications and windows on
their screens, one of them being MS Excel. It is always a pain to constantly shift back to Excel just to view a small set of data cells. Therefore, I am curious if it is possible to somehow transfer the data of a very small set of cells into some sort of text box object that is constatly visible somewhere (anywhere) on my screen??? It would be great if I could find an object that can somehow detach itself from the confines of a spreedsheet and kind of float somewhere on the side so it's always visible. Anybody got any ideas??? Thank you soo much! Everyone here has been so incredibly helpful! Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text boxes which can float outside the Excel application!
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) "Robert Crandal" wrote in message ... My users typically have multiple different applications and windows on their screens, one of them being MS Excel. It is always a pain to constantly shift back to Excel just to view a small set of data cells. Therefore, I am curious if it is possible to somehow transfer the data of a very small set of cells into some sort of text box object that is constatly visible somewhere (anywhere) on my screen??? It would be great if I could find an object that can somehow detach itself from the confines of a spreedsheet and kind of float somewhere on the side so it's always visible. Anybody got any ideas??? Thank you soo much! Everyone here has been so incredibly helpful! Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text boxes which can float outside the Excel application!
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) |
#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) . |
Reply |
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) |