把窗体内的代码改成L
Private Sub UserForm_Initialize()Me.TextBox1.Value = Sheet1.[a1].ValueMe.ComboBox1.AddItem "张三"Me.ComboBox1.AddItem "李四"Me.ComboBox1.AddItem "赵五"Me.ComboBox1.AddItem "钱六"Me.ComboBox1.AddItem "孙七"Me.ComboBox1.AddItem "王八"End Sub
使用道具 举报
将A1赋值给文本框
怎么赋值ActiveSheet.Cells(7, 5) = TextBox1.Text
这样吗????我设成这样还是没法显示
反了,TextBox1.Text=ActiveSheet.Cells(7, 5) =
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-14 15:45 , Processed in 0.322158 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.