Найти в Дзене
Excel VBA Programming : Address Book With Image
I have developed an address book in Excel that can add pictures for records and I wanted to share it. Student database, personnel database etc. can also be used for other purposes. Useful a userform to save people’s information such as name, phone number, address. I made some additions to the userform to add people’s pictures...
4 года назад
Create Table Of Contents With Macro In Excel Sheet
In Excel , table of contents can be automatically created a with a macro. This macro creates a new sheet named "Workbook_Index" as first sheet of workbook. The macro then lists in this sheet the names of all the sheets in the workbook and inserts a hyperlink for each one...
4 года назад
Ms Excel : Easy Way To Enter Date Into Active Cell
The calendar form is displayed when it is double-clicked on any cell on the worksheet.Months are listed in the combobox control according to the user's system language starting from the month on the userform caption ...
4 года назад