This userform allows editing of cells via textboxes.
A character can be added using command buttons.
It does not work when a cell has integers only. I've tried converting to text using "CStr" but no luck.
How can I make it work?
Form code is shown below. Other parts of the code are in the workbook.
Please Login or Register to view this content.
It doesn't seem to work for any of the cells for me, text or integers or both.
As you have moved on to this, is your previous issue resolved?
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
No, my other issue is still outstanding.As you have moved on to this, is your previous issue resolved?
OK - just checking. You might wish to bump it (which is allowed once a day).
As I mentioned above, this user form does not work for me in Excel 365 at all, although it's not entirely clear how it is meant to be used!
I guess I'm using Excel 2007.does not work for me in Excel 365
The form will also contain Greek letters and other miscellaneous characters that cannot be typed. It will be used to edit and equation. So if want to have an equation with the character "∞" just click a button to add it.not entirely clear how it is meant to be used
That should make no difference - VBA should (I believe) be forward compatible. I have never seen any issues except with 64-bit 365, which I don't have.I guess I'm using Excel 2007.
So basically you want to use this as a shortcut to Insert > Symbol?
I think it would be really helpful here, and in the other thread, if you gave a step-by-step example of how you are testing these forms, e.g.
1. Select the range x to y.
2. Click to open the form ... etc.
3. Result: X Expected result: Y
This would make troubleshooting easier and more precise, as we'd all be doing exactly the same thing. At the moment there are too many possible variables! You need to approach this a bit like a scientific experiment.
OK. It's basically.
1. Select range.
2. Click to open form,
3. Select box you want to edit.
4. Place cursor where you want the character to be inserted.
5. Insert character using a command button.
Nothing counter-intuitive.
The issue in my opinion is that cells with "integers only" are not treated as a string. I tried to convert to a string using "CStr" but no success.
1. Select range - which range?
The devil is in the detail - you MUST be precise and specific!
No, but remember it's obvious to you because you keep doing it, but until now you have not told us EXACTLY how you are testing this.Nothing counter-intuitive.
I sense that you resent being asked for extra details, and I rather feel that you also think I'm a bit thick. I hope that I am wrong about both.
OK - so now I know how to use the form, I can confirm your findings. This would have been useful to share:
The debug is indicating an error in this line of code if I try to insert a character into the integer only cell.Please Login or Register to view this content.
I can see what the issue is, but my VBA skills aren't good enough to help fix it: an entry that has all characters or a mixture of characters and integers is seen by Excel (and VBA) as a text string. When there are just integers, it's a number, and the code is looking for a text string, hence the error message.
Last edited by AliGW; 11-01-2019 at 03:49 AM.
Yes I do hate going into the details, this is because I think all the information is in the original post.
No I don't think you're thick, that would be me.
This is the range you want to edit, or place a special character in there. The benefit of a range is that you can edit more than one cell at a time. The benefit to doing this is that I don't have to open up Character Map and search for special characters.1. Select range - which range?
As suggested it does not work on cells which are integers only.
Please see my edit to the post above.
The problem is that you HAVE to go into detail if you want to get these issues solved quickly. Just because you think you've given enough detail doesn't mean that you have: remember, it is YOU that is looking for help here!
If you fail to give the detail requested, your helpers will lose interest and give up on you - that's the bottom line. I really do feel that this is why your other thread has stalled - you have been reluctant to answer questions and failed to explain, step-by-step, what you are doing so that your helpers can replicate it exactly.
I am saying this to try to help you to get solutions to your problems, not because I am targeting you in any way.
Yes but most of my questions have gotten resolved, which is a much better outcome than I anticipate.
I do understand about the volunteer aspect of it.
Yes this is what I'm trying to say.code is looking for a text string
You'll either need to prefix the cell with an apostrophe or ensure it's formatted as text before the data is entered.
Everyone who confuses correlation and causation ends up dead.
The point is that the code requires a text string, so what you need is code that will accept either text or numbers (that's the bit I can't help you with).
I said nothing about anyone here being volunteers (that was yesterday) - my point today is that if your helpers don't get the precise detail they need to be able to troubleshoot your issue, then they just move on to something else they can help to solve.
Yes, most of your issues may have been solved - I am trying to help you get a resolution to this and yesterday's issues. Anyway, I shall bow out now and leave this to the VBA experts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks