Insert values in cells (MsgBox)

**Lv27** · 10-09-2012, 09:02 AM

Hello

I have a minor problem that I really hope one of you can help me with.

Through a "problem solver process" in VBA I get some values that I want to insert in certain cells. The code is below (I am not giving the entire code as that seems to be unnecessary)

Please Login or Register  to view this content.

Problem is that nothing changes when I press yes in the messagebox? (even though the messagebox did say that optimal values were found)...

**arlu1201** · 10-09-2012, 09:05 AM

Is this code specific to a particular sheet? Are you running it in a module or as a worksheet event?

**Lv27** · 10-09-2012, 09:09 AM

A module... And yes it is to a particular sheet. But basically I just get two values iBest and jBest that are shown in a messagebox - the code works that far. The problem occurs when I want the values to be shown in the cells C2 and C3 - the MsgBox does pose the question but nothing happens when I press yes :/

**arlu1201** · 10-09-2012, 09:18 AM

You will need to declare the sheet names before the range. For e.g.

Please Login or Register  to view this content.

**greggy99** · 10-09-2012, 09:20 AM

hi lv27

try this

Please Login or Register  to view this content.

hope its help...^_^

**thisisgerald** · 10-09-2012, 09:23 AM

Hi Lv27

Please try this code below.

Please Login or Register  to view this content.

Hope it helps.

Regards,
thisisgerald

**Lv27** · 10-11-2012, 10:29 AM

Thanks a lot for all the answers! I think the problem was that I had used Application.ScreenUpdating=False in the beginning of the code - and when I ran it with F8 I stopped before the "Applic....=True" part

My bad, but thanks anyway!