Adding to some existing VBA code

**richard11153** · 03-10-2014, 02:39 PM

I have some working VBA code that lets me do two things.
1) When I click in a cell (with a "q" in a cell, directly to the left of it) it puts an "X" in the cell.
2) When I click in a cell (with a "/" in the cell, directly to the left of it) it puts a "wingding symbol" in the cell.
These work perfectly. I would like to add one more component, the same "type/way" as above. (see next line)
When I click on a cell (with a "z" in the cell, directly to the left of it) I want it to put in the letters "FE". (same way as above)

Can someone modify, or add to my VBA code (shown below), so this will work??
If you could send me back the full (modified code), that would be great.
Thanks.

Here's my VBA code;

Please Login or Register  to view this content.

**judgeh59** · 03-10-2014, 02:58 PM

so close on the Code tags....the end one should be "[/code]"

you should be able to add another ElseIF and copy your "q" code and then change it to z and FE...

**richard11153** · 03-10-2014, 03:08 PM

I'm lost with "changing or adding" to code.
Can you add or modify my code in the post, and send the entire "modified" code back?

Thanks

**richard11153** · 03-10-2014, 03:08 PM

I'm lost with "changing or adding" to code.
Can you add or modify my code in the post, and send the entire "modified" code back?

Thanks

**richard11153** · 03-10-2014, 03:15 PM

I tried it, (adding the new section). The old code still worked but the added line did nothing.

**slx** · 03-10-2014, 03:29 PM

Originally Posted by richard11153

I'm lost with "changing or adding" to code.
Can you add or modify my code in the post, and send the entire "modified" code back?

Thanks

Judge is referring to your post on this forum. You didn't use the tags properly.

**richard11153** · 03-10-2014, 03:33 PM

Wow, Does it really matter that much?
I think I have it right now.

**judgeh59** · 03-10-2014, 03:35 PM

not a lot, there are a few reasons....

1) it is a forum rule the moderators will give you infraction points.
2) and more importantly it hold the formatting of your code and makes it easier to read for the folks trying to help....

so, I was trying to help you not get infraction points and see if I could figure out your VBA issue....which I'm working on....hope this helps....

**richard11153** · 03-10-2014, 03:40 PM

Thanks, I really do appreciate the help.
I may already have some "infraction points" I guess.

**judgeh59** · 03-10-2014, 03:42 PM

no problem....I don't seem to be able to get your code that you have post working, much less add to it....can you attach a macro enabled workbook with data that is not company confidential?

**richard11153** · 03-10-2014, 03:53 PM

I have a "working sample" worksheet I can send, but I'm not seeing where / how, to attach it.

**judgeh59** · 03-10-2014, 03:55 PM

Scroll to the bottom and you should see a Go Advanced and scroll down in there and you should see a attachment area....it using a weird browse kind of system but it works....

**richard11153** · 03-10-2014, 03:59 PM

Found it.

Here's is a working sample of the VBA

**richard11153** · 03-10-2014, 04:02 PM

This is with using excel 2003 (if it matters)

**judgeh59** · 03-10-2014, 04:12 PM

see if this gets you closer

Please Login or Register  to view this content.

**richard11153** · 03-10-2014, 04:16 PM

No, Not working. The original code still puts the X & wingdings in,
But the added code, does nothing.

**richard11153** · 03-10-2014, 04:18 PM

No, The Original code part is working, but the added code is doing nothing.

**judgeh59** · 03-10-2014, 04:19 PM

seems to work on my machine....here is the file....did you copy my code in or just type in the addition?....because I added code to the top also....

**richard11153** · 03-10-2014, 04:36 PM

I copied the entire code before. I also just downloaded & tested the "adjusted" file you attached.
It does not work as it should (putting the FE "in or out" each time the cell is clicked on).
There is improvement however, at least the curser, now moves into the cell on the left as it should.
But no "FE" appears when clicked on.

**richard11153** · 03-10-2014, 04:37 PM

I have to go out for a while, Ill be back in a hour or so, to see if you or anybody else
can figure this out. Thanks for the help, so far. This stuff is never easy!!

**richard11153** · 03-10-2014, 06:30 PM

I just played with the code a bit. I see it puts an FE in the cell, but when you click on it again,
it does not go back to "blank" as the other boxes do. It looks like if that can be fixed, I'm all set.
Any suggestions?

**jindon** · 03-10-2014, 08:31 PM

http://www.excelforum.com/excel-prog...ml#post3614289

Please Login or Register  to view this content.

Adding to some existing VBA code

LinkBack

Thread Tools

Rate This Thread

Display

Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Re: Adding to some existing VBA code

Thread Information

Users Browsing this Thread

Similar Threads

Existing VBA that needs loop adding to the code.

Adding cell zoom code to already existing code in single worksheet

Help adding to existing code

Adding Code to an Existing UserForm with VBA

adding to an existing line of VBA code

Bookmarks

Bookmarks

Posting Permissions