» Linking a Cell to a Text Box
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To link a cell to a Text Box object:
1. From the Drawing toolbar, click Text Box.
2. Select the Text Box, and press F2.
3. In the Formula Bar, create a link to a cell by typing = and then selecting the cell.
The contents of the cell are displayed in the Text Box.

Book Store:
help me out
tawfiq Posted on: 31-12-1969
i'm having a near 300 contact in my excel file and i imported that file to outlook contact in the format of csv.. but now i'm having problem .. once i go to inbox and click on address box and in the contact i can able to view the name but once i click on the name .. instead of email address nly ; is appearing .. plz help me out.. Reply: help me out - tawfiq from india wrote on August 9, 2003 2:35 AM EST
Alan Posted on: 31-12-1969
Hi Tawfiq,
To be fair, this is really an Oulook (Contacts) problem, not Excel.
However, it sounds to me that you may have had an error in the mapping of fields from your Excel data to Oulook when you imported the list.
If you open up the contact in Outlook itself, does all the data appear to be in the correct fields, with nothing missing?
If you right-click on the email address, and select properties, what have you got in there as the 'display name' or similar?
Hope that helps,
Alan
Combo Box properties
Tiffany Posted on: 31-12-1969
Hi~
How do I go about having a specific cell trigger an "if" formula when a user selects a specific value from a dropdown box list?
Thanks!!!


