Cheat Engine

asianking · Posted: Mon Jun 06, 2011 5:42 pm Post subject: need help with excel

Is there a way I can call a formula that automatic adds comma's to any data entered in rows A onto B2? So for example:

A1: red
A2: blue ------> B2: red, blue, white
A3: white

So any data enter after A3 will automatic added to B2 with a comma before it.

B2: red, blue, white, green

samuelarnold · How do I cheat? Reputation: 0 Joined: 07 Jun 2011 Posts: 6

Formula for adding commas, i think no way... Sad

AhMunRa · Posted: Tue Jun 07, 2011 11:23 am Post subject:

Formula no, but you could write a vb macro that could do this.

asianking · Posted: Fri Jun 10, 2011 6:04 pm Post subject:

you mind get me a head start? I'm not too familiar with vb codes for excel. It's not like the same command as visual basic.

AhMunRa · Posted: Fri Jun 10, 2011 8:09 pm Post subject:

I'm not really good with VB Macros either. Alot of the stuff we use at work used to be Excel and macros but we have been moving away from them.

lucidity · Posted: Fri Jun 10, 2011 9:37 pm Post subject:

I think it'll be like this (untested):

Dim Value = Worksheets("Your-Worksheet-Name").Range("A1:A1").Value
Value &= ", "
Value &= Worksheets("Your-Worksheet-Name").Range("A2:A2").Value
Value &= ","
Value &= Worksheets("Your-Worksheet-Name").Range("A3:A3").Value

asianking · Posted: Sun Jun 12, 2011 4:40 pm Post subject:

not sure what version you using, but mine doesn't work with those codes.

InternetIsSeriousBusiness · Posted: Sun Jun 12, 2011 6:53 pm Post subject:

asianking · Posted: Sun Jun 12, 2011 7:51 pm Post subject:

2007...Thanks for the tip, but I got it to work after doing some research.

Point A is the actual codes. Point B is to auto run the macro upon open the file so I don't have to press a shortcut keys to just run macro or press run.

[/img]