Question about dates.

[superbeast326]

I have two columns, A and B. Both have 50 rows. Column A is filled entirely with "No". What I want is that the moment I switch a row in Column A to "Yes". I want the row in Column B to store the date that the change was made. Is this possible?

 

[Peter_SSs]

Thanks Peter. I see what you mean, that when you manually adjust column width, you get a box showing width in pixels.

But, on the other hand, if I have a column of width, say, 1 pixel, as in 1 single screen element, and I double the zoom factor, then surely the column now takes up 2 screen elements, and 2 pixels ?

Did you try it? Set column A width to say 60 pixels at 100% zoom. Now increase the zoom to 200%. Click the column divider between columns A and B. Does it not still say 60 pixels?

 

[superbeast326]

The question I posed, was an hypothetical one. I do have a genuine one. I have actually read up on the INDIRECT function. However, I would like to know, how and when should I use the function. The reason for this is that, I am experiencing severe confusion in regards to this particular function?

By the way, thank you all for your input.

 

[Gerald Higgins]

Did you try it? Set column A width to say 60 pixels at 100% zoom. Now increase the zoom to 200%. Click the column divider between columns A and B. Does it not still say 60 pixels?

Peter, thanks, yes I had tried it after your earlier post, that's what I was implying when I said "I see what you mean". I agree that the Excel box which says how many pixels the column is wide, is unaffected by zoom factor.

BUT, I always thought of a pixel as being a physical element of the screen itself, and if that's what a pixel is, then increasing the zoom factor MUST mean a column becomes more pixels wide. That's why I was wondering if Excel has a different definition of a pixel, which I think must be the case.

 

[superbeast326]

Peter,

How can I multiple cells above a single cell using VBA. Basically, how do I lock and unlock multiple cells. Can I use offset to do this?

 

[superbeast326]

What I meant was,

How can I lock multiple cells above a single cell?

 

[Peter_SSs]

You could remove the 'Locked' property from all the cells in the worksheet then apply it back on the cells you want locked, then protect the worksheet. Try turning the macro recorder on, doing the above steps manually then turn the recorder off.

That will give you some code to start working on. If the code does not do what you want, step through with F8 to see where it goes wrong and have a go at modifying it. If you still cannot get it do do exactly what you want, post the code you have and explain in what way it isn't working (eg error details, what it did incorrectly etc).

 

[superbeast326]

I have formulated a code that works perfectly. I have another problem, I have 50 DV Lists, Yes and No inside all of them. I also have five pictures in the worksheet, that changes based on the number of "Yes". What I would like to know is, how can I delete all the pictures once all 50 DV Lists are switched to "Yes".

Also, is it possible for the column, with a DV List recently switched to "Yes", to autofit its width programmatically. This is because, I have texts underneath the DV lists and I want the texts to fit nicely within the cells.

 

[Peter_SSs]

I should have said this much earlier in this thread. New questions really should be posted in new threads. There are a few reasons ..

1. The thread is no longer about dates. People who are date experts could see the thread title, spend a lot of time going through this long thread, only to find the current question is one they are not interested in or not proficient at.

2. People who are not good at dates probably won't even look at the thread because of the title, yet may be expert at you current question.

3. Whatever the title, very few people will bother to look at a thread with this many replies, so you are greatly restricting your chance of getting the best person to answer the question.

 

[superbeast326]

Okay, I will do that ASAP. By the way, thank you.

 

[superbeast326]

Peter,

Please do, kindly, post in all of my other threads.

Thank you.