I am running office 2007. I want to use exel spreadsheet in a booking programme and would like to be able to have a calendar that you can pick month and date eg in online booking systems. Any ideas if this can be done in exel
Thanks for info. It appears that this function is not available in Exel 2007. On another point is it possible when you enter a particular cell that this could be displayed in another cell eg if i had a range of cells with numbers 1 to 5 and i went onto cell 3, could this be displayed or any other one displayed in another cell thanks
Assuming that your numbers 1 to 5 are in A1:A5 and you want to display the result in B1
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Intersect(Target, Range("A1:A5")) Is Nothing Then Exit Sub Application.EnableEvents = False Range("B1").Value = Target.Value Application.EnableEvents = True End Sub
Right click the sheet tab and select View Code. Copy and paste in the above code then close the code window. Clicking in the range A1:A5 will display the value of the selected cell in B1.