Search results for query: *

Many thanks Tony. That worked a treat. I'll use the new register in class tomorrow. Best wishes, Realbeginner

Thanks! There is still a problem. Everytime I try to run it says: Runtime error 424 Object required Any suggestions? Have I got the code in the wrong place?

Hi. I'm still having problems with the colour of the button. The following CODE gives a grey box which says "Run-time error '424' Object required" Debug highlights the Button1.BackColour line. Any ideas? Sub Button1_Click() ' ' Button1_Click Macro Present With ActiveCell .Formula = "1"...

Hi. I'm making an EXCEL register with buttons to use on an interactive whiteboard in the classroom. I'm almost there but I'm stuck on the last two bits: - Could you show me how to click a button to input today's date so that it stays as that date (i.e. not a function) - Could you see what I've...

Hello again. I wanted to change the colour of my buttons and I'm having problems. Can you see what I'm doing wrong here? CODE Sub Button1_Click() ' ' Button1_Click Macro Present With ActiveCell .Formula = "1" .Offset(1, 0).Select End With Button1.ForeColor = RGB(0, 255, 0) ' Colour -...

Many thanks! That was really helpful.

Hi. I want to use VB to create a button in EXCEL which puts a 1 in a cell then moves to the row underneath. If I click the same button I want it to put a 1 in this new cell and move downwards as before. I know this is simple stuff but I'm really stuck! (I can put a button in and record a macro)...

Hi. I want to use VB to create a button in EXCEL which puts a 1 in a cell then moves to the row underneath. If I click the same button I want it to put a 1 in this new cell and move downwards as before. I know this is simple stuff but I'm really stuck! (I can put a button in and record a macro)...