Change cell value

[Sunil Dushila]

Hi,

i am having a two sheets(Sheet1 and Sheet2) in my workbook. i want to change cell (C5) value in sheet 1 with column from Sheet2 (A5:A30).

I want to right vba code like, if i click on a command button, cell value of C5 in sheet1 changes with cell value in column_A (Range A5:A30) on a one run. i tried different way to right a code but it's not working. In simple, way i want to run a loop who change C5 value in sheet1 with values in column_A (A5:A30).

thanks,

[alansidman]

Your explanation is a little confusing. Tell me how you will determine which cell in Range A5:A30 on Sheet 2 will correspond to the be the value on Sheet 1 in Cell C5. We need more information. For instance your logic to make this happen. Talk to us as if we were standing in line for coffee at Starbucks and explain your situation.

Your saying you tried a way but is not working does not help. We cannot read your mind or know what you tried. Help us to help you by telling the whole story. Attach a worksheet to make the explanation easier. I am sure it is clear in your mind, but you've fuzzied mine up.

[Solus Rankin]

Please Login or Register  to view this content.

[Sunil Dushila]

sorry about my thread. i should send a sample file with that...

[Sunil Dushila]

Please find attached sample of my thread

[Solus Rankin]

Book2(1).xlsm Attached.

[Sunil Dushila]

in above sample, what i want is?

I want to right a loop on command button, click event.

which change sheet1 C2(Highlighted Cell) value with values on sheet 2 in column A (A5:A34).

I hope this make sense what i am looking for....

[Sunil Dushila]

Hi Solus,

Thanks for your efforts much appriciated

but i want ro change values in one run.

like in attached file i have to click on command button everytime to change the value.

but i want to click on once and it changes values until loop o reached on A34 sheet2.

[alansidman]

Your explanation is still not making any sense. Please explain the simple logic of what this button is to do. Step by step. What is the criteria that will put what value in the highlighted cell. Give us a realistic example. If you want a loop, then explain what the loop is looking for.

[Solus Rankin]

It sounds like you want to spin through all those values like a slot machine, displaying each in C2 for a given amount of time.

[Sunil Dushila]

Hi Alan,

I don't know if it's possible or not what i am trying to achive.

ok

what i want is:

Step one: when i click on command button.

it run a loop and pulls values on sheet2 in column A to cell C2 on sheet1.

i want to loop starts from first value in column A (A5) from sheet2 and ends on A34.

each time loop change C2 value with the next value in column A...

for example:

when i click on command button

loop will start
and it will pulls

Afghanistan from A5 (sheet2) to cell C2 on sheet1 then
Albania from A6 (sheet2) to cell C2 on sheet1..... so on up to Burundi (which is on A34 sheet2)

on a single click

[Sunil Dushila]

So

this is not possible. is this what you are trying to say?

[alansidman]

Why would you want to do that. Each time you loop through a name using a macro, it will replace the prior name. It will cycle through so fast you will not see anything except the last item. It will happen in less than one second. I don't understand your thinking or rationale. Why not just select the last item.

[alansidman]

Here is what you asked for, but I don't understand the need.

[Sunil Dushila]

Hey Alan,

you are a star man

you solve my problem.. many thanks to you

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.