excel - 用于定义 VB 动作的 Excel 公式 - 请在单元格更改值后帮助刷新
问题描述
我正在用 excel 创建一个标签打印应用程序。用户将从下拉菜单中选择产品,然后将查找值以填充单元格 A1、B1 和 C1(X 或 0)
X 表示显示菱形,0 表示隐藏。
如果我手动更改值,钻石会出现/消失。如果我使用下拉菜单,公式会更改单元格 A1、B1 和 C1 的值,但 VB 会忽略更改。有任何想法吗?谢谢你。
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then _
Me.Shapes("Diamond 1").Visible = (Cells(1, 1).Value = "x")
If Target.Row = 1 And Target.Column = 2 Then _
Me.Shapes("Diamond 2").Visible = (Cells(1, 2).Value = "x")
If Target.Row = 1 And Target.Column = 3 Then _
Me.Shapes("Diamond 3").Visible = (Cells(1, 3).Value = "x")
End Sub
解决方案
推荐阅读
- javascript - Inherit props and functions from vue parent instance
- postgresql - Importing XML with PostgreSQL
- python - Creating time series df with category and date and percentage change
- swift - Untrusted certificate HTTPs load failed on Swift5
- mongodb - Update many values in nested array mongodb
- android-animation - How to set motion layout transition to one activity to another
- itfoxtec-identity-saml2 - Need to add Attributes in AuthNRequest.. How can this be done?
- javascript - How can I add type3 for random to build scene from 3 type
- java - ActiveMQ 5.16.3 Windows and Hawtio Login Problems
- java - 如何通过服务创建具有卷的容器?