Hello ilovelagar,
You must have recorded the macro. The default property for a Range object is the Value, which will be the result of a formula. The only way to get the formula into the TextBox is to use the Formula property.
Example of Returning a Cell Value to a TextBox
Example of Returning theCell Formula to a TextBox
TextBox1 = Range("C3").Value
TextBox1 = Range("C3").Formula 'A1 style TextBox1 = Range("C3").FormulaR1C1 'R1C1 style
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ilovelagar 
Register To Reply
Bookmarks