Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Recently KevHardy asked a question with a very nice text and Master Mike H. (who can also inititate chemical reactions in Excel when needed I believe) has given the solution, effective, easily understandable as always. (It was on Feb 11 or 12). The answer was a macro like: "Private Sub CommandButton1_Click() If Selection.Rows.Count 1... In that answer - Alt+F11: I learned it. Then should I say insert MODULE or different ? - Then, I inserted the 'command button' on the worksheet, okay. Right click the 'command button, select 'Assign Macro' then I could not see the macro I wrote ? (I could run it by copying, pasting etc., a long way). Additional question, can I find the list of commands like "Selection.Rows.Count" etc. somewhere in the internet. Thanks and regards, Cousin Excel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning Macros | Excel Worksheet Functions | |||
Assigning macros | Excel Discussion (Misc queries) | |||
assigning macros | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons | Excel Discussion (Misc queries) | |||
Problem Assigning Macros | Excel Worksheet Functions |