sorry i will be back laterPlease Login or Register to view this content.
sorry i will be back laterPlease Login or Register to view this content.
Last edited by AliGW; 01-26-2018 at 06:27 PM. Reason: Code restored and code tags added.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Also could you add how it isnt working. Do you get an error message, does it return the wrong result or no result (what do you get and what do you expect to get)? Does the formula work correctly if you place it on a sheet manually?
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
yes getting some error code
Why have you deleted the code? You were asked to put code tags round it, not delete it. Do you still need help? If so, then I will add the code tags for you as a gesture of goodwill, however you must do this yourself in future.
Hello aliakbaram85,
Welcome to the Forum!
The problem I see is you are assigning a Text value to an Integer. TextBoxes always return text values. I have modified your code to change the text to an integer.
Please Login or Register to view this content.
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thanks a lot Leith Ross
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks