Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 7th, 2006, 10:27 AM
Registered User
Join Date: Jan 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default New User having trouble with Zero Values

Hello everyone,

I am working on a spreadsheet in Excel which has 3 fields in the left portion of the worksheet. Line one is a patients name, Line two is the insurance id # (social security # followed by 1-3 letters) and line three is a medical records number. On the left of those fields are information (dates and payment levels) to determine the facilities payment for each patient during different time periods of their stay. My problem is that I don't want to show zero values for the date section because when I need to print the report, not all of those dates will be entered. I do need to show zero values for the social security #, otherwise it will not print correctly. I attempted to use VBA code like this:

Private Sub Worksheet_Activate()
Selection.EntireColumn.ShowZeros = True
End Sub

But it isn't working. Can anyone help me figure out what is wrong with this code??

Thanks!!! Sorry for being so new. I have been learning for only about 2 months.

Old January 8th, 2006, 09:15 PM
Authorized User
Join Date: Nov 2004
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts


     I think you should use conditional formating for this cause. it can do the task that you require both visually and through code. it is available in "Format" Menu. Try this one out, hope this will help


Similar Threads
Thread Thread Starter Forum Replies Last Post
user profile trouble Maxxim BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 7 October 9th, 2007 06:24 PM
Dynamic user control- not able to set values ghari ASP.NET 1.0 and 1.1 Professional 0 January 4th, 2006 01:16 AM
Trouble with returning parameter values EricJ VB.NET 0 July 5th, 2005 08:58 AM
Using JDialog to get values from user pratheeba Java GUI 1 October 9th, 2003 02:30 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.