Replies

Thank you Roger …

I haven’t worked (yet) with object references and stuff like that …
but I did find a post (584,261) that should help me create an object reference.

Again, thanks,
Cindy

Hans, you are wonderful !!! You are always there when I need you. This forum is really making me look good at work !
Thanks,
–cat

Hi Hans,

I was creating my reply to Legare I guess while you were posting your reply ! You have answered most of my questions … is Target the name of the worksheet?
Also, how do you keep the indenting in your replies?

Thanks,
–cat

Thanks, Legare.

This is the macro I came up with. I had to fudge the ranges, due to rounding, but I think it works.
I’m not sure where to place it for a Worksheet Change event, though. I’m sorry.

We have a Quality Control department that takes the displayed numbers in reports and uses a calculator to determine the accuracy of the numbers.
Since the cell still contains the original number, I will need to use the “Precision Displayed” setting in Options for any further calculation.
And linking these cells to other locations, means that I will need to run a macro in the other locations, too, if I want the same type of display. The first time the link is done, it picks up the numberformat of the cell. However, if the data/cell changes, the linked cell will still contain the original numberfor. Hmmm… I think I’m getting a headache!

Anyways, how do I do a Worksheet Change Event?

Thanks,
–cat

Sub DecimalDisplay()
‘
For r = 9 To 35
CalcNum = Range(“C” & r).Value
If CalcNum = 0.9995 And CalcNum = 9.995 And CalcNum = 99.95 Then
Range(“D” & r).NumberFormat = “0”
Range(“D” & r).Value = CalcNum
End If

Next r

End Sub

Thanks, Legare

Hi Jan,

Thanks for your suggestion. Unfortunately, this company wishes to use the Shared feature in Excel primarily for the Audit Trail it produces. Having multiple users is simply a benefit. And, this company, doesn’t have Access or any Access people.

Thanks,
–Cindy

Hi Hans,

Fortunately, when I went to try your suggestions, I found that I COULD now open a shared Excel file when there was someone else in it. I think it was a network traffic issue (and, the IT person now thinks so too).
But, thanks! And, by the way, what would holding the Shift Key down when opening a workbook do?

Thanks,
–Cindy

Hi Hans,

It does contain a lot of VB code … but, I’m a “self-taught” VBA coder and have not intentially used object libraries … so, I think the answer is no …

–Cindy

Thank you, Legare, for the clarification.
–cat

Thank You! I don’t know much about arrays and I really like ability to manipulate text as numbers by the trick of multiplying by 1 !!!

I love this site!
–cat

The new function, Indirect.ext, works perfect for me!

Thanks, Hans.

Hans, how do you know so much?!

I am currently downloading the add-in and will place a post with how it works …

Thanks!
–cat

Thanks, John. I’ll just try to duplicate what I need and not display the Appointment tab.

(Just feeling a little frustrated since this company hired me to do an excel/vb project and now I’m working in Outlook …. )
–cat

Sorry … It seems it took the server quite a while to know that this folder was deleted … the folder no longer exists in my Favorite Public Folders.

Guess I’m just impatient ….

Thanks,
–cat

Thank you very much. I learned a lot about customizing the Calendar from the steps you provided. And, I was able to copy the holidays to the public calendar!

You are very kind and helpful,
–cat