Hi All
I want to display value in excel using vba in the following format
12/20
and i am using the following statment for this
ws10.Cells(iR0, 2).Value = TextBox2.Value + "/" + aa
but it gives an error "type mismatch". Could anyone please help me
Regards
Aman
Per forum rules please encase your code within CODE tags - Edit your last post, highlight your VBA and press the # icon at which point we may assist you.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
aman1234
As pointed out by DonkeyOte whenever you post VBA/macro code you need to use code tags
Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks