[SOLVED]Change Macro to enter full amount

[auntsally]

Evening all

I know nothing about macro's and the person that created the macro on this sheet is not here. Can anyone change it for me/advise what to do?

At the minute we press ctrl+E (on cell C5 on Sunday page) and enter 2 rounded up figures in the pop up boxes (i.e 32, then 2, the 2nd amount is deducted from the first) what we want to do is enter 2 full figures (i.e 31599 and 2499) and then have the macro round the figure to the nearest thousand.

Is this possible?

Sal

[shg]

Replace the code that's there with this:

Please Login or Register  to view this content.

[auntsally]

Thanks for that.

I've changed the code but the only thing thats not working is the actual CTRL + E part of it. We can do ALT+F8 then run the macro and it works fine, but CTRL + E doesn't do anything.

I've checked security settings and made sure I clicked enable macros when opening the sheet. I've also tried changing the key combination. Any idea what might be stopping it?.

[royUK]

Don't replace the whole sub. Open the original workbook, Alt+F11 to open the VB Editor.Then paste Shg's code below over the existing code after

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[auntsally]

Thanks for the reply

Ok, so now i've got the code as shown below but still nothing happens when I do CTRL E.

Please Login or Register  to view this content.

[martindwilson]

works for me but you have to reassign ctrl+e in tools/macro/macros/options

[royUK]

The shortcut worked for me just pasting the body of the code

[auntsally]

Ah, thats the problem. It's on CTRL+SHIFT - I cant remove the SHIFT part of it.

[auntsally]

NVM, stupid caps lock! Just realised thats why it wants the shift key.

Thanks for all your help