Search results for query: *

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!!

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

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 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...

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

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...

Hi, How is everyone today? Hope someone could offer some quick help. I am trying to use VBA to find and select a cell within a certain column. The criteria is based on what the user selects from a list box. Here is the code I have so far. I get an error: Object variable or with block variable...

I am having some trouble with finding the next empty row. I have read faq707-2112 I am sure my answer is in there but I am just not getting it. This is probably a snap but I cant seem to make it work. I am very new to VBA so thanks in advance for your patience Here is the scenario I have a...

Hi, I have checked the help files - maybe i'm not asking the right way. I cant seem to find a way to sort based on cell formatting. I have conditional formatting in place - if Column A=ColumnB the Color is red if A>B color is Blue etc. I want to be able to sort by that condition - am I making...

Hi, This will seem like a simple question - sorry. I thought you could have 26 nested if statements, I keep looking and I cant see why this is wrong - can you help? I am looking to match up a list from a form ( i have multiple checkboxes associated with cells - when one is true (checked) i want...

Hi, Hoping you can help me. I am making a chart in Excel here is a simple example of the criteria: 1996 Data 1 Data 2 Dept 1 0.82 0.97 Dept 2 1.29 1.18 Dept 3 0.79 0.79 Dept 4 1.52 1.84 Dept 5 1.28 1.56 1997 Data 1 Data 2 Dept 1 0.65 0.87 Dept 2 1.43 1.06 Dept 3 0.57 0.71 Dept 4 1.33 1.66...