Ask for an Excel button problem

See if you can understand no, just helped you do the first one.

Press alt and f11 at the same time to enter the macro interface, insert, module, paste as follows**:

dim iflag as boolean

dim i as integer

sub movedown()

if iflag then

iflag = false

elseif i = 12 then

i = 0else

i = i + 1

end if

range("a" & i * 28 + 17).select

now + timevalue("0:0:2"), "movedown"

end if

end sub

sub stopm()

iflag = true

end sub

A bold 12 means 12 pages;0:0:2 in bold means 2 seconds (if you change it to 0:0:5, it will be 5 seconds).

28 and 17 in bold, not very easy to understand: take my current excel file as a column, the first 4 rows are frozen, about 28 rows is a page (actually 32 rows, because there are 4 more frozen rows);And 17 makes sure that each page turned is exactly 28 lines. Try to adjust it yourself.

Then go back to excel, insert two shapes somewhere in the first 4 lines (such as text boxes and the like, one writes to turn pages, one writes to stop), right-click the shapes, and make the macro movedown and stopm respectively, and that's it.

Figure out the rest for yourself.

Use of command buttons in excel forms.

1. Open Excel, right-click in the blank space of the toolbar, and select "Form" in the pop-up menu

4. Loosen the window and a window will pop up. Click the Cancel button.

5. Right-click in the worksheet and select "View**" in the pop-up menu

6. Enter in the VBE window to add a module.

7. Enter the following ** in the module.

sub btn_click()

end sub

9. Right-click the command button and select "Assign Macro".

10. Select the macro you just added in the "Specify Macro" window.

The functional design is more complex than the form menu, the control toolbox menu, and the operation steps are as follows.

a) Form menu.

Place the mouse over the blank space of the toolbar (or the menu bar).

Right-click and a pop-up box will appear.

Select the form. Click the button, drag it on Excel, and there will be a pop-up box specifying the macro.

Click Record, click New, and you can see something like **.

sub button10 Click ().

end sub

b) Controls toolbox menu.

Place the mouse over the blank space of the toolbar (or the menu bar).

Right-click and a pop-up box will appear.

Select the Controls toolbox.

Clicking on the design pattern (in the top left corner, like a triangle icon) is a crucial step that many people just don't know.

Click on any of the small boxes, and the small boxes are in a state (there are nine small gardens like periods, enclosed).

Place the mouse on the small box, right-click, and a pop-up box will appear.

Select view**, you will enter the import system template, see the following process, there will be ** in the process.

private sub checkbox1_click()

end sub

The functional design is simple and linked, and the operation steps are as follows.

Select any cell.

Go to Formatting.

Then adjust the upper left border to light thin lines, the lower right border to dark thick lines, and the background to other colors, and one button is done.

Then enter the hyperlink, link to other pages or files, click, you can have the function of opening other pages or files, just like the software click button to open other interfaces.

Modify the whole table a little more, and add some ** and it will be very much like software.

Add a scroll bar or numeric adjustment to the worksheet.

1.Open the Excel software, right-click in the blank area of the toolbar, and in the pop-up options, select "Customize Quick Access Toolbar".

2.Switch to the Customize Ribbon and select Development Tools on the right, then OK.

3.In this way, you can see the development tools in the menu bar, switch the development tools interface, select Insert tool, and you can see two button icons.

4.The first is the form control, which is generally used to manipulate macros, and you can record or specify the macro first, so that you can create a button in **.

5.The second is ActiveX, which is generally used to perform VBA programming, and in design mode, the double-click button can enter the VBA programming environment.