Recent content by cjjn

Thank you so much for your help - and quick response. Worked like a charm! Thanks again - have a fantastic day!

Hi there Is there a way to code in VBA for Excel - that if a particular cell is empty - it wont allow close? My help files in VBA are not installed and thought I may get an answer quicker this wat than waiting for my service desk to re-install them. Thanks!!

oh well that's a shame! Thanks so much for your help John.

Thanks John I have it all set up now - but if I make a change to the Excel data sheet - it will not automatically update changes on the Org chart - any ideas? have a I done something wrong? Thanks again.

Hi I am very new to visio - creating an org chart - used the wizard. If i want the visio file to link to the excel sheet with my data - do i need to somehow code that or is there a function built in to do that? sorry if that seems like a lame question thanks in advance c

No, I had tried both ways before posting.

Oh man Ever have one of those days where you feel dumb as a post?! Thank you PHV. Now what happens if I want the form to close once data has been entered and they click my OK button? I have 'Unload Me' in there - but it still doesnt close the form. Thanks again.

Hello, I have read this and i have just one silly question... Where do I put the code that gives the Message Box? Thanks in advance

Hi Newbie question How do I have a form open when a workbook is opened? Thanks in advance. Christy

Hi Skip, I am looking for a similar solution, would you mind sharing an example with me as well? Thanks cjjn

Hi there, I am very - very new to Visio. I am creating an org chart and have 2 questions... I have found how to add custom properties, now I need to know how to make them export when I click export data. The custom property is a job description, I was hoping that if I could export it - I...

Thanks! Wow that was a simple solution - I should have thought about what I was doing before looking for a complicated answer. [upsidedown] Thanks so much for your time. cj

Thanks John Sorry - I do not think I explained myself very well. Right now I am using countif <> 0. This works great - however it will count the null cells too because they do not =0 either. The way I read the FAQ is that the criteria would be in 2 different columns. I need it to only look...

Hello I looked in the FAQs before posting and found a great one 68-4725. I just have a further question if anyone can help. What if I want to do basically a counta - with a condition? I only want it to count the cells that have been entered into - that do NOT = 0. Any ideas? TIA

Worked! Thanks so much - really I appreciate your taking the time.