Hi Folks,

I need some advice on how to make a user interface friendly. I have a
macro sheet that has a list of tasks that is periodically loaded by
another controlling macro sheet. The sheet with the list of tasks is
used by an end user that has a requirement to quickly be able to click
on a button or a cell to capture tasks being performed in a day.

As indicated the list is dynamic and contains anywhere from 10 - 800
rows, therefore adding buttons beside each row is probably not a good
idea (as row heights will change, and I would need a way to associate
a row to a specific button, and also every time the list changes, the
number of buttons would have to be adjusted - either deleted and then
recreated). Originally this macro was coded using buttons, however it
was done for a known small number of entries in the list.

I have changed this, so that a double click on the cell that is to be
incremented increments a value in the cell clicked on automatically.
Problem is that when you double click it leaves you in edit mode on
the cell double clicked. This I believe will be seen as not
friendly. Though having said that, there could be the odd situation
where an end user may require to go into a cell and just put in a
value.

Does anyone have a suggestion where when you have a dynamic list being
loaded into a macro sheet, that has a requirement for an end user to
quickly add one to total for a specific list item (ideally with one
click), but also have the option to just go into the cell and hardcode
a value?

much appreciated,
Regards,
Enzo

It is kind of dangerous to increment data just clicking on a cell, i double
click by accident all the time, what I would do is put either a spinner
button in the menu or 2 buttons, an up and a down, then code them to
Activecell=Activecell+1. then they click on the cell they want to chnge, then
click the button to increment/decrement. You could even assign the macro to
keystrokes so they could change the active cell on Ctl+Shift U and Ctl+Shift
D.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Enz" wrote:

>
> Hi Folks,
>
> I need some advice on how to make a user interface friendly. I have a
> macro sheet that has a list of tasks that is periodically loaded by
> another controlling macro sheet. The sheet with the list of tasks is
> used by an end user that has a requirement to quickly be able to click
> on a button or a cell to capture tasks being performed in a day.
>
> As indicated the list is dynamic and contains anywhere from 10 - 800
> rows, therefore adding buttons beside each row is probably not a good
> idea (as row heights will change, and I would need a way to associate
> a row to a specific button, and also every time the list changes, the
> number of buttons would have to be adjusted - either deleted and then
> recreated). Originally this macro was coded using buttons, however it
> was done for a known small number of entries in the list.
>
> I have changed this, so that a double click on the cell that is to be
> incremented increments a value in the cell clicked on automatically.
> Problem is that when you double click it leaves you in edit mode on
> the cell double clicked. This I believe will be seen as not
> friendly. Though having said that, there could be the odd situation
> where an end user may require to go into a cell and just put in a
> value.
>
> Does anyone have a suggestion where when you have a dynamic list being
> loaded into a macro sheet, that has a requirement for an end user to
> quickly add one to total for a specific list item (ideally with one
> click), but also have the option to just go into the cell and hardcode
> a value?
>
> much appreciated,
> Regards,
> Enzo
>
>