Thread: Listbox Code
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kemal@intelinfo.zzn.com is offline
external usenet poster
  
Posts: 27
Default Listbox Code
To put under Worksheet Change Event

If target.column=3 and target.row=1 then
if target.value="No Change" then
target.offset(1,-1) = ""
target.offset(,-2)=""
end If
end if


Reply With QuoteReply With Quote