Prev: How do I filter the cells based in Fill color?
Next: Vlookup with corresponding two data (blank and non blnk)
From: Reg on 28 Apr 2010 06:04
Well its possible but still unclear -

How does data get into E2
what data is it - does it need to be preserverd, is there a formula or
validation to worry about?


"Dan Wood" wrote:

> That works to clear the entire column, but isn't quite what i need.
>
> The sheet is to store passwords, then there is a macro to add appointments
> into outlook for the date the password needs changing. Therefore, in column
> 'A' starting at row 9 there is a list of system names. Then in column 'D'
> starting in row 9 again is the date that the password expires, and this is
> added to the calendar. Column 'E' is simply there as a way to stop duplicate
> entries in the calendar. So what i want is for example if the system in A12
> password expires, it will then be changed and the new expiration date will be
> input into D12, so i only want E12 to be cleared.
>
> Is there some way to do this, or is it to complicated?
>
> Thanks for your help
From: Dan Wood on 28 Apr 2010 06:31
I will try to describe as best as i can!

Starting in Column A9 downwards there will be a list of system names that
will updated by the user. From B9 downwards is the new password the user
enters. C9 downwards is the date the user changed the password, which again
is enetered by the user. Cell D9 will be locked, but is basically the formula
=C9+30, and will display the date the password will need changing. This date
is used by the macro to add the appoinment into outlook calendar. Cell E9 is
filled in automatically by my original macro which, once the appoinment has
been added, is filled in with 'Done'.

So when cell C9 date is changed, i want cell E9 to clear, so that when i run
the macro to add appoinments, which will be as a button, it will spot that a
cell in column E is empty and add that appointment
From: Reg on 28 Apr 2010 07:11
I suggest you modify your macro to clear column e when it sets up
appointments and column e says 'done'

RegMigrant


"Dan Wood" wrote:

> I will try to describe as best as i can!
>
> Starting in Column A9 downwards there will be a list of system names that
> will updated by the user. From B9 downwards is the new password the user
> enters. C9 downwards is the date the user changed the password, which again
> is enetered by the user. Cell D9 will be locked, but is basically the formula
> =C9+30, and will display the date the password will need changing. This date
> is used by the macro to add the appoinment into outlook calendar. Cell E9 is
> filled in automatically by my original macro which, once the appoinment has
> been added, is filled in with 'Done'.
>
> So when cell C9 date is changed, i want cell E9 to clear, so that when i run
> the macro to add appoinments, which will be as a button, it will spot that a
> cell in column E is empty and add that appointment
From: JLatham on 28 Apr 2010 07:29
Dan Wood,
You are best off using Mickey's code, or a variation of it, in the worksheet
code module of the sheet you are interested in. To put any
Private Sub Worksheet_event()
code into a worksheet, simply choose it and right-click on its name tab and
choose [View Code] from the list. That brings up that specific sheet's code
module for use.

If you use the ThisWorkbook object code and the
Private Sub Workbook_SheetChange()
event, the code will work on EVERY sheet that a change is made on as
indicated in the code unless you test to see which sheet had the change
within the code.

"Dan Wood" wrote:

> I will try to describe as best as i can!
>
> Starting in Column A9 downwards there will be a list of system names that
> will updated by the user. From B9 downwards is the new password the user
> enters. C9 downwards is the date the user changed the password, which again
> is enetered by the user. Cell D9 will be locked, but is basically the formula
> =C9+30, and will display the date the password will need changing. This date
> is used by the macro to add the appoinment into outlook calendar. Cell E9 is
> filled in automatically by my original macro which, once the appoinment has
> been added, is filled in with 'Done'.
>
> So when cell C9 date is changed, i want cell E9 to clear, so that when i run
> the macro to add appoinments, which will be as a button, it will spot that a
> cell in column E is empty and add that appointment
From: Dan Wood on 28 Apr 2010 07:37
Ok i will try that. Is there a way then to get cell E9 to fill when cell C9
is changed?

Thanks for all your help with this
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: How do I filter the cells based in Fill color?
Next: Vlookup with corresponding two data (blank and non blnk)