Recent content by PBAPaul

Thank you all for your very helpful replies. mintjulep: I was wondering that I might have to change CDate() to a different function like DateValue(). mintjulep: I am using Excel 2010. MS very kindly stopped offering DatePicker etc in this version onwards. Andrzejek: I tried your code which...

I have a userform which uses various text boxes operated via spinbuttons. I successfully use the following code to vary the date: Private Sub SpinButton1_SpinDown() TextBox1.Text = Format(CDate(TextBox1.Text) - CDate(SpinButton1.SmallChange), "dd mmmm yyyy") End Sub Private Sub...

My very inadequate code is: Private Sub SpinButton1_SpinDown() TextBox1.Text = TextBox1.Text - Worksheets("Sheet1").Cells(TextBox1 - SpinButton1.SmallChange, 1).Value End Sub Private Sub SpinButton1_SpinUp() TextBox1.Text = TextBox1.Text - Worksheets("Sheet1").Cells(TextBox1 -...

I have a problem, in Excel 2010, using the spinbutton in a form accessing a range in a worksheet. I will try to explain the problem. I have a range in a worksheet called "MyDrugs". It is in a column eg A1 to A20 and contains the names of medications that I have to take. I have a UserForm that...

Dear Andrzejek Thank you for your help. Sorry that I set this question in the wrong forum. Paul

I wish to use VBA to change the value in the relevant text box in a full formatted value. ChangeWednesday, 21 March 2018 With a spin to [indent]Thursday, 22 March 2018 I have a spreadsheet calculation that I can use to show the day from the date but I want a single spin to be able to change...

Hi All I am sorry that this might be a simple question but unfortunately I am in hospital away from my usual environment of reference books, files and seemingly at the moment – Brains! I have a complex Excel workbook (Medications Control.xlsm) that controls a number of internal and external...

I found the setting at HK_USERS\S - 1 - 5 .......\Software\Microsoft\VBA\7.0\Common. I renamed the Setting from "Dock" to "OldDock", closed the registry and restarted Excel. JOY! It has reverted to the default. Thank you very much for your help.

The link to restore default settings refers to HKEY_USERS\.Default\Software\Microsoft\VBA\Office. Unfortunately, my system does not have the reference to VBA. My Registry only shows HKEY_USERS\.Default\Software\Microsoft\Office\Excel or Word etc. I am running MS Office 2010 in Windows 10...

Great! Thank you.

I have Excel VBA code that opens a Word 2010 document and calls the Word macro. The Word macro is a simple print program which I have checked and it works as it should. If I step through the Excel macro then everything works as intended. However if I attempt to run the macro, it gets to the...

I have stupidly managed to completely buggar up (please excuse that technical term) the layout of the macro sheets in my Excel 2010 Workbooks. I have used the default Excel for layout for so long that I am very used to it. I used to have the Project Explorer Window docked vertically to the left...

Thanks. Works a treat!

I have just upgraded my systems from Office 2003 to Office 2010. In a VBA project that was created in Office 2003, I need to copy a sheet from a file to each of the other computers on my network. I use the 2003 VBA code of "NameOfComputer" I use this to find the name of the initiating computer...

Thanks Combo Have a star! Paul