Search results for query: *

Thanks tviman, code works great, appreciate the help CB

Hi all Just wondering if anyone can help with my query. All I would like to know is if a spreadsheet is saved as .htm, is there a way to save the spreadsheet so that macros will still run. While building a sample sheet I could get links to work but buttons running macros didn't seem to. Any...

Hi all, Hope someone can help. A web site I have taken over supporting has links that I am having problems with. From the home page a link opens an excel spreadsheet in the browser, (current code: <a href='file location'>) From the spreadsheet another link then opens another webpage. The new...

Hi everyone This maybe really simple but I tried most of the code I could find and can't get it to work. What I would like to do is on a button click > Open worksheet > Search down column A till the first empty cell > Enter details in cells along this row id. I know how to open the...

Hi Skip Thanks for the quick reply, code works great, thanks for the help Craig

Hello everyone Can anyone tell me how I get the button click values from a message box. I need the values to complete an if else statement in the code. Thanks in advance for the help Craig

Hello people Thanks for the help, didn't realise there were 2 methods we could use to add buttons, adding them from the form bar worked a dream. Acron, I coundn't figure out how to create and save a template, our network looks like it has been set up so we are unable to do this, but I used...

I have created a Macro that creates a new work sheet and then copies formatting from 2 other work sheets to make an order form. What I would like to do is add buttons to the spread sheet when it is created so that when they are clicked the order amount for the associated item is entered in the...

Hi people Have sorted this problem out through trial and error. the code I ended up using is below Sub Create_New_Orderform() ' ' Create_New_Orderform Macro ' Creates new Order form ' ' Keyboard Shortcut: Ctrl+n ' 'Range(&quot;A1:D9&quot;).Select 'Selection.Copy todaysDate =...

Hi there I have an Excel Work book that contains various order forms. I have macros that create new work sheets copying the original Order forms depending on which is run. What I want to do, I would like to change the name of a newly created worksheet to the date the work sheet was created. Is...

Hi jennuhw The code below is what I used over an NT network to get the user login id of the person who accessed the spread sheet. Hope this can be of use Craig [bigglasses] Private Sub getname_Click() Dim userName As String userName = CreateObject(&quot;Wscript.Network&quot;).userName...

Hello people Thanks for the responses,I'm going to get the sender to resend in another format, .xls or something I know I can open. Appreciate the help and advice. Craig

Hello everyone received a file with a .123 extension. I don't recognise the format and am unable to open it in Excel which I was told I would be able to. Can any one advise me on how I might be able to get it open. Thanks Craig

Hi Everybody Thanks for the code samples. I trialled all the code supplied and ended up using the code below. The help is really appreciated. Private Sub getname_Click() Dim userName As String userName = CreateObject(&quot;Wscript.Network&quot;).userName MsgBox userName End Sub Craig...

Hi Guys Thanks for all the help. I did forget to mention that this is on an NT network, so could you tell me how to use the Environ$(&quot;User&quot;) code as this is new to me. Thanks Craig

Hello I recently created a spread sheet to provide reporting on regular checks that need to be carried out. Multiple users access this spread sheet and I would like to be able to store their user id's in a cell when they open the spread sheet. As only one user can access this spread sheet at a...

bjdc4jc, thanks for your help, your advice worked great. The code below is what I ended up using. Hope that helps others as well. Private Sub cmdDataOKYes_Click() Static count As Integer Dim cellstring As String cellstring = &quot;c&quot; & count + 6 Range(cellstring).Select With...

I need to know how to program a button on an Excel spreadsheet to colour a single cell in a column when clicked and then on the next click the next cell is coloured and so on. I have written a macro that does half the job(see below)but I can't figure out how to go to the next cell on the next...