Excel on my computer is work well with UserForm and Spreadsheet 11.0. When I copy the excel file to another computer and install OWC that you provided (restart computer as well), but its still the same.
What are the VBA objects/collection that control and can manipulate the numpages and pages fields. Also if I want to create a simple user form or code that allows the user depending on the number of different sections in a document control the starting number for each section.
I will tell you why i need this. I have a userform that has a calendar control on it. Now in my project the column A is date. I want my userform to come up, when user clicks on any cell in column A and just chooses the date from calendar. My macro for the calendar is ready.....but its the problem to call it. FYI, i will paste that macro here.
Let's say that the text boxes are named (left to right, top to bottom) txtRin, txtGin, txtBin, txtRout, txtGout, and txtBout. And let's say you place a command button cmdOK on the userform that will run the code. The On Click event procedure for the command button could look like this:
I have created a userform in Outlook, and when filled out the users clicks the button on the form and an email is created and sent. The sent email has voting buttons for the recipient to use. The email that is sent has voting buttons as this process is to gain approval for an action. Depending on the case, there may need to be one level of approval or 2 levels of approval. Case 1: Sender sends ...
1. I set a variable in Datepicker1_change as following: Datepicker1_change () Date1=Datepicker1.value end sub Userform_initialized () Datepicker1.value=Date1 End Sub The problem is that when I exit from Excel, the default date changes to 1/1/1899
I found the limitations with using the menus to modify the toolbar UI to be unacceptable (hard-coded pathnames to the file and macro embedded in the toolbar button's XML!? ridiculous! How the heck can you distribute anything with that as the default configuration? answer: you can't!) so I found out how to embed the customUI in the workbook file. started out ok, but then I made a critical ...
