determine if value in pivot table

G

geebee

hi,

I have a combobox with a list of value in sheet1. and wen i make a selection
it performs the followig:

sheeta("pivot").range("C6").value = sheets("lookup").range("B4").value

i would like to know if there is any kind of way to add some code to
determine whether or not the value selected via the combobox exists in te
pivot table BEFORE the preceding code is executed. this is to prevent the "x
value does not exist.. rename x to y".

thanks in advance,
geebee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table: Determining item from one field based on anotherfield item 0
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
VBA Pivot Table Error 1
Pivot table code question 2
pivot table 1
selecting cells to produce a pivot table 4
check if value exists in pivot table 0
Using macro to switch 'page' in a pivot table? 1

Top