Marking a cell

  • Thread starter Thread starter DoctorC
  • Start date Start date
D

DoctorC

Hi,
sorry if I bother you, but I need a fast solution as the boss is waiting
for the spreadsheet.

I need an holiday planner where clicking on a cell marks it as
holiday/working day.
I.e. each employee marks on this spreadsheet the holiday days clicking
on the cells that indicate the days he chooses.

How to add such a functionality? I never used macros or VBA, but I'm a
programmer and keen to learn

Please help me.

Enrico
 
Hi,
Hilite any range of cells and then use the macro recorder,
goto the font bar and select webdings
next enter a (lower case) in the formula bar and hit Ctrl+enter
then stop recording,
select another range of cells, run the macro and see what happens

if you look at the code it may be quite overwhelming, but if you cleaned it up, it will look something like this

Code: 
Sub Button1_Click()
 '
 	With Selection.Font
 		.Name = "Webdings"
 		.Size = 10
 	End With
 	Selection.FormulaR1C1 = "a"
 End Sub
 
Back
Top