Search results for query: *

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

Thanks PH but my question was not that simple! If I click on C3 then I can obviously use the Activecell properties to get the column and row designation. What I want to do is get the column designation of where the cursor is. Let's say I click on C3 then move the cursor away to be in A2 BUT...

I have a spreadsheet with 8 columns. There are 8 rows starting at row 2. What I want to do is to show in row 1 a calculation - which is dependent on the column in which the cursor is in and in previous calculations - in the column in which the cursor is located. The problem is that I do not...

Thank you CMP. The technique works like a dream! Paul

Hi All I have a system that will generate an invoice by using a worksheet "Invoice" and using VBA to enter the various details. The worksheet "Invoice" is formatted with borders, left and right aligned text, emboldened text etc. I can send this as an attachment but some recipients may not have...

Hi I have a form where I have 20 combo-boxes in a line. These represent the useage of rooms in a hotel. I want to place captions above each of these combo-boxes to show the name of the appropriate room. The best way would be for the captions to read vertically ie text turned through 90...