Entering data using a mouse click
 

Hi. I want to enter simple data (a figure 1) into a series of cells while on
the telephone (its for a phone based questionnaire). Is there a way of just
pointing at the cell and clicking on the mouse that will le me do this? Many
thanks. Rob

Entering data using a mouse click
 

How about a double-click??

Put the following in worksheet code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = 1
Cancel = True
End Sub

double-click any cell to set it to 1
--
Gary''s Student


"Cheers100" wrote:

Hi. I want to enter simple data (a figure 1) into a series of cells while on
the telephone (its for a phone based questionnaire). Is there a way of just
pointing at the cell and clicking on the mouse that will le me do this? Many
thanks. Rob

Entering data using a mouse click
 

gary

Thanks for that but its a bit beyond my current capabilities! A double click
is fine but how do you put something in worksheet code ?

Rob

"Gary''s Student" wrote:

How about a double-click??

Put the following in worksheet code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = 1
Cancel = True
End Sub

double-click any cell to set it to 1
--
Gary''s Student


"Cheers100" wrote:

Hi. I want to enter simple data (a figure 1) into a series of cells while on
the telephone (its for a phone based questionnaire). Is there a way of just
pointing at the cell and clicking on the mouse that will le me do this? Many
thanks. Rob

Entering data using a mouse click
 

Cheers100

Right click on the worksheet tab & goto "view code" and place the code in
the open space on the right side of the screen.

Mike Rogers

"Cheers100" wrote:

gary

Thanks for that but its a bit beyond my current capabilities! A double click
is fine but how do you put something in worksheet code ?

Rob

"Gary''s Student" wrote:

How about a double-click??

Put the following in worksheet code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = 1
Cancel = True
End Sub

double-click any cell to set it to 1
--
Gary''s Student


"Cheers100" wrote:

Hi. I want to enter simple data (a figure 1) into a series of cells while on
the telephone (its for a phone based questionnaire). Is there a way of just
pointing at the cell and clicking on the mouse that will le me do this? Many
thanks. Rob

Entering data using a mouse click
 

Mike and gary

Well I never thought it would work having never heard of worksheet code but
it has!! Fantastic - many thanks to you both.

Rob

"Mike Rogers" wrote:

Cheers100

Right click on the worksheet tab & goto "view code" and place the code in
the open space on the right side of the screen.

Mike Rogers

"Cheers100" wrote:

gary

Thanks for that but its a bit beyond my current capabilities! A double click
is fine but how do you put something in worksheet code ?

Rob

"Gary''s Student" wrote:

How about a double-click??

Put the following in worksheet code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = 1
Cancel = True
End Sub

double-click any cell to set it to 1
--
Gary''s Student


"Cheers100" wrote:

Hi. I want to enter simple data (a figure 1) into a series of cells while on
the telephone (its for a phone based questionnaire). Is there a way of just
pointing at the cell and clicking on the mouse that will le me do this? Many
thanks. Rob