VBA code asistance with If Function to check PivotTable value

**Sintek** · 08-13-2016, 04:33 AM

Hi All

I have the following code which populates my textbox with a sales value for today taken from a pivot Table. Problem is, when their is no sales for today as yet, it throws an error. How can I add an If statement to check if Today sales is "0.00" and if so, to populate TextBox with "0.00" Else populate as per normal

Please Login or Register  to view this content.

Something like:

Please Login or Register  to view this content.

**Kaper** · 08-13-2016, 07:09 AM

Not a "proper" solution (and not tested - I'm writing on a smartphone), but shall work:

Please Login or Register  to view this content.

**Sintek** · 08-13-2016, 07:41 AM

Hey There Kaper

Works great, thanks as always.

VBA code asistance with If Function to check PivotTable value

LinkBack

Thread Tools

Rate This Thread

Display

VBA code asistance with If Function to check PivotTable value

Re: VBA code asistance with If Function to check PivotTable value

Re: VBA code asistance with If Function to check PivotTable value

Thread Information

Users Browsing this Thread

Similar Threads

VB code to add outside border to Pivottable

How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In

need asistance applying a simple formula to a formatted cell

[SOLVED] Check If Value Exists in PivotTable (as a PivotItem)

Pivottable code problem

Programming Comments from the inside!! Asistance Please

[SOLVED] check the cell format by function or vba code

Bookmarks

Bookmarks

Posting Permissions