Author Topic: Need some help from those good at Excel/Visual Basic (Read 7520 times)

CaffeineJunkie · « **Reply #15 on:** October 10, 2006, 09:34:45 PM »

OK, works for me when i use this code (see screenshot)

how did you get the cmdbutton14_click() statement? did you type it in??

_tom_ · « **Reply #16 on:** October 10, 2006, 11:18:37 PM »

Yeah I typed in cmdButton14_click() in.. I'll follow your code so hopefully it will work..

CaffeineJunkie · « **Reply #17 on:** October 10, 2006, 11:20:16 PM »

what's the exact name of your button?

if it's definitely cmdButton14 then something else is wrong, but i'd put money on it just being Button14

_tom_ · « **Reply #18 on:** October 10, 2006, 11:21:18 PM »

Yeah its called Button14. I dont know why I called it cmd :lol: Absolutely useless. Cheers for the help

CaffeineJunkie · « **Reply #19 on:** October 10, 2006, 11:34:02 PM »

that'll be the problem then, what do i win :lol:

_tom_ · « **Reply #20 on:** October 10, 2006, 11:36:12 PM »

The satisfaction of helping someone who's shitee at programming? :lol:

I dont have any real prizes :D

CaffeineJunkie · « **Reply #21 on:** October 10, 2006, 11:47:47 PM »

lol, thas kool, i'll just go back to being smug

_tom_ · « **Reply #22 on:** October 11, 2006, 03:21:45 PM »

Yay it worked :D Now.. how the hell do you change the colour of macro buttons in excel? In format controls theres no bit to change the colour of the button, and that grey looks awful :(

CaffeineJunkie · « **Reply #23 on:** October 11, 2006, 06:01:52 PM »

you can't i don't think

the best thing you can do in that situation is to put a picture of a button in there, and then put another graphic in for the rollover.