- Excel中如何使用VBA实现自动隐藏和显示行？
- Excel中如何使用VBA实现自动隐藏和显示行？
- 求助 :::: VBA编程 !!! 怎样点击单元格使此单元格所在的行变颜色 !!!!!
- Excel如何用函数或者代码使值为隐藏的单元格所在行自动隐藏，本人是菜鸟，恳请各位大神详细介绍下方法
Excel中如何使用VBA实现自动隐藏和显示行？
首先向这样的哥们表示最崇高的敬意,只有我们不满足于软件的功能,才不断推动了软件的进步,同时也使我们的软件市场无比的繁荣!!! 其次,你已经具备了一个进行二次开发的精神并且你现在已经在做二次开发的工作了,但你的工具不行.工欲善其事,必先利其器.就算excel再好,你的许多需求也得最起码使用excel的vba程序设计部分来完成了. 最后,祝你可以在知识的台阶上百尽杆头,更进一步. 如果你有sql的基本,那最好找本dephi,vb等等之类的书看一下,然后画个漂亮的界面,做个漂亮的报表,就万事ok了. 最后最后一句,你的高度,excel已经满足不了了,该升级了. 参考 http://wenwen.sogou/z/q895346551.htm 可以的，用VBA。工具---》宏---》VB编辑器。程序不难。 篇幅太长，一下讲不清楚。看帮助也能学会的。 参考 http://zhidao.baidu/question/70938931.html?si=9 http://office.microsoft/en-us/training/CR061831141033.aspx http://office.microsoft/en-us/training/CR061831141033.aspx 这是英文的介绍 音频的 http://www.microsoft/china/office/xp/excel/ http://www.microsoft/china/office/xp/excel/ 相应的中文要你找的。 Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office. Contents [hide] 1 History 2 Versions 3 Logos 4 File formats 4.1 Microsoft Excel 2007 Office Open XML formats 5 Criticism 6 See also 7 References 8 External links [edit] History Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which was very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. This promoted development of a new spreadsheet called Excel which started with the intention to, in the words of Doug Klunder, 'do everything 1-2-3 does and do it better' . The first version of Excel was released for the Mac
Excel中如何使用VBA实现自动隐藏和显示行？
首先向这样的哥们表示最崇高的敬意,只有我们不满足于软件的功能,才不断推动了软件的进步,同时也使我们的软件市场无比的繁荣!!!
其次,你已经具备了一个进行二次开发的精神并且你现在已经在做二次开发的工作了,但你的工具不行.工欲善其事,必先利其器.就算excel再好,你的许多需求也得最起码使用excel的vba程序设计部分来完成了.
最后,祝你可以在知识的台阶上百尽杆头,更进一步. 如果你有sql的基本,那最好找本dephi,vb等等之类的书看一下,然后画个漂亮的界面,做个漂亮的报表,就万事ok了.
最后最后一句,你的高度,excel已经满足不了了,该升级了.
参考 http://wenwen.sogou/z/q895346551.htm?si=10
可以的，用VBA。工具---》宏---》VB编辑器。程序不难。
篇幅太长，一下讲不清楚。看帮助也能学会的。
参考 http://zhidao.baidu/question/70938931.html?si=9
http://office.microsoft/en-us/training/CR061831141033.aspx
http://office.microsoft/en-us/training/CR061831141033.aspx
这是英文的介绍 音频的
http://www.microsoft/china/office/xp/excel/
http://www.microsoft/china/office/xp/excel/
相应的中文要你找的。
Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office.
Contents [hide]
1 History
2 Versions
3 Logos
4 File formats
4.1 Microsoft Excel 2007 Office Open XML formats
5 Criticism
6 See also
7 References
8 External links
[edit] History
Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which was very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. This promoted development of a new spreadsheet called Excel which started with the intention to, in the words of Doug Klunder, 'do everything 1-2-3 does and do it better' . The first version of Excel was released for the Mac in 1985 and the first Windows version (numbered 2.0 to line-up with the Mac and bundled with a run-time Windows environment) was released in November 1987. Lotus was slow to bring 1-2-3 to Wind
求助 :::: VBA编程 !!! 怎样点击单元格使此单元格所在的行变颜色 !!!!!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 13 Then
Cells.Interior.ColorIndex = xlNone '如果不需要清除原来的颜色，此行可删除
Target.EntireRow.Interior.ColorIndex = 3
End If
End Sub
打开EXCEL。按ALT+F11,粘贴以上代码。
Excel如何用函数或者代码使值为隐藏的单元格所在行自动隐藏，本人是菜鸟，恳请各位大神详细介绍下方法
条件格式，值等于4的单元格填充字体为白色。就差不多等于隐藏起来了。