I created a basic shape in excel.I first used a formula =map!a1 and hot reference of the cell.Now I tried using =text(a1,"mm-dd-yy") and got error.I was not able to view it because it came and flashed away.Different new file same issuesCan we use any formula in shapes like we use in cell?
Originally Posted by Svmaxcel
I usually put the results of the formula (=TEXT(A1,"mm-dd-yy")) that uses the cell (A1 in your example) in a cell that will be covered by the shape (E9 in the attachment)
The shape formula can (I believe) only reference a basic cell address, so the shape formula would be =E9
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
You can use a named formula but you have to initially set the name up to just refer to a range, and then alter it after it has been assigned to the shape.
Be as you wish to seem
You may change the formatting of the cell (map!a1) you are referring in shape.
Go to format cells (Ctrl+1) while map!a1 is selected.
then custom format and put "mm-dd-yy".
Posting Permissions
Reply With Quote
