Search results for query: *

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.

Thank you again, That looks like a good plan. I apologize for yet another basic knowledge question - but here it is. The checkbox I am using is named in Excel as Check Box 35 I know I cannot use spaces in the naming in VB - I tried quotes but it does not work. How do I reference it in code...

Thank you kphu! That worked much better - but now sends the e-mail to both, even if Cell B31 is TRUE. I am using a check box - if it is checked then the linked cell (B31) would be TRUE. I am not sure that cell value still works in this case as it does not seem to recognize when it changes to...

Hello, I know this is going to be painfully simple - but I need help. Here is what I would like to do - if Cell B31 is true - I would like for an email to be sent to just one person however - if it is False or blank, I would like to have the file sent to 2 people. Here is my code - I keep...

[upsidedown] pretty cute!

Hi Loomah, yes it does. they are dates - does that matter? would it be better if i had the value of the listbox put in a cell and then reference that cell's value in my search instead? Thanks for your help. C