Hi, struggling a bit with the below code.
The VLOOKUP bit works fine. The issue I have is if I delete the contents of "C15", The previous VLOOKUP result remains as a caption instead of renaming the caption to "Blank"
Any help would be greatly appreciated.
Please Login or Register to view this content.
MTIA
But ... do you call the piece of code you presented above after deleting C15?
May be you shall update button caption every time C15 changes.
If so, use Worksgeet_Change event code in your sheet (the one where C15 is located) to call procedure writing new cation to Button24 (the snippet above).
Best Regards,
Kaper
Dear Kaper,
Many thanks for your response. What is bizarre is that it is part of a worksheet change event already. see below. It just doesn't change back....
[CODE][/Private Sub Worksheet_Change(ByVal Target As Range)
'ActiveSheet.Protect UserInterfaceOnly:=True
With Application
.ScreenUpdating = False
' disable events
.EnableEvents = False
End With
On Error GoTo here
If Range("J73").Value >= 100000 Then CommandButton24.Visible = True
If Range("J73").Value < 100000 Then CommandButton24.Visible = False
ActiveSheet.CommandButton24.Caption = Application.WorksheetFunction. _
VLookup(Range("C15").Text, Worksheets("PSL Vendors").Range("B2:J2000"), 9, False)
If Range("C15").Value = "" Then ActiveSheet.CommandButton24.Caption = "Blank"CODE]
MTIA
Hi,
Here you have shown that you are disabling events processing:
Where you enable it back?Please Login or Register to view this content.
Is it after label here:?
If C15 is blank, the VLOOKUP will fail and goto the label here ... so that's where you need to check the value of C15Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks