+- Las Venturas Playground (https://forum.sa-mp.nl)
+-- Forum: Miscellaneous (https://forum.sa-mp.nl/forum-4.html)
+--- Forum: General Talk (https://forum.sa-mp.nl/forum-24.html)
+--- Thread: excel VBA (/thread-28568.html)
excel VBA - [NB]Zaibatsu - 12-07-2011
hello maybe someone can help me solve some questions about VBA in excel:
![[Image: vba.jpg]](http://www.upload.ee/image/1871876/vba.jpg)
so
what do i need to type to VBA when i need:
1.if i enter a positive number into yellow area, the box will change to blue (the same box where i typed the number)
2.if i enter a negative number into yellow area, the box will change to red
3.if i type any number on any other location (not in yellow area), nothing will happen
4.to have the sum of the positive numbers into the blue box in top
5.to have the sum of the negative numbers into the red box in top
thanks in advance
)))))))))))))))Re: excel VBA - IDmad - 12-07-2011
do ur own homework u noob!
Re: excel VBA - [NB]Zaibatsu - 12-07-2011
tryin but ure not doing it for me
Re: excel VBA - thiaZ - 12-07-2011
I'm not sure if that or that may help you, but I hope so. You would basically have to check for the value in the cell, if it is < 0 make it red (RGB -> 255, 0, 0), otherwise make it blue (RGB -> 0, 0, 255), I never worked with VBA in Excel, so you would have to do that on your own, except someone else here could help you.
Re: excel VBA - Gaahl - 12-07-2011
http://neddyy.net/docs/
Hitman gave me the link to this page, awesome shit dude.
Re: excel VBA - XiZ - 12-07-2011
(12-07-2011, 06:22 PM)Gaahl link Wrote: http://neddyy.net/docs/That german faggot knows his cheater shit. Still, it did me good once.
Hitman gave me the link to this page, awesome shit dude.
Re: excel VBA - Blackbean - 12-07-2011
(12-07-2011, 06:22 PM)Gaahl link Wrote: http://neddyy.net/docs/Thanks for the link. will be using it alot.
Hitman gave me the link to this page, awesome shit dude.
Re: excel VBA - [NB]Zaibatsu - 12-08-2011
still open for suggestions