Search results

Tableau pivot?

I don't know ,Is this te result dat you want? I guess that you mean with rotate ,transpose. Maybe post a small example with the result that you want. I do understand French

Delete all hyperlinks. Can be done with this code in the active sheet Sub del() ActiveSheet.Hyperlinks.Delete End Sub Next put this code in the ThisWorkbook module Private Sub Workbook_Open() Application.ScreenUpdating = False For Each wsSheet In Worksheets wsSheet.Visible = False...

Post your example, I have look to make it in access.

The first question is why? Why not make it in Access, it would be a lot easier. But here you have an example.

Your sample is ok,just add a new sample with the changed userform

If your userform is ready,I can help you with the coding.

Right click on the selected area and click Format Cells. Click the Alignment tab at the top of the pop-up menu. In the Alignment tab, open the Horizontal dropdown and select Center Across Selection. Click OK to finalize.

Without an example. See if this works for you. Private Sub cmbUpdate_Click() With Sheets("Master") iRow = .Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1 .Cells(iRow, 1).Resize(, 20).Value = Array(txtPrefix, cboStatus, txtSuffix, txtShopOrdNum...

With your setup it will take al lot of (unnecessary) coding. You should use one userform with tabs as you can see in this picture. Then you won't have problems with multiple submit buttons,finding the right row and any other obstacles

Does this helps?

Something like this? The attahment is a zipfile. It contains the excelfile and a folder with some images. Unzip the file and test the excel file. In the excelfile, select a name in the combobox, the rest is filled automatically. Change the pictures with yours, except the 2 that are named male...

Glad to help.:)

Like this?

Something like this?

Glad to help.:) but all the credit goes to Logit.

You placed the code in the sheet module,you have to place it in the ThisWorkbook module as stated in post #4 (see screenshot)

Hi Peter, Thank you for your contribution

Perfect, thank you so much for your time.:awesome:

Rounded before adding time You gave me the perfect formula to add 10 minutes extra,I need the same formulas for 9,18 and 60 minutes as example, with your given formula if the cell is 2:00, the end result is 2:20 (2 times 10 minutes) what is 100% correct but I want also for example to add 60...

Yes,this is what I am looking for. Except there are 3 more: 9 mintes,18 minutes and 60 minutes They can be separate formulas, they don't have to be combined. Extra info: the hours are round up (on 5 minutes)

I have a result in a cell formated as uu:mm, for example 3:00, Then I need to add 3 times 10 minutes in another cell result should be 3:30 in a another cell. If the first cell is 2:30 then the result should be 2:55 (2 times 10 minutes and 1 time 5 minutes) The goal is when somebody works on a...

@Yodelayheewho I've been out of the loop forr 11 months.(I was in the hospital) I am a bit rusty. I see your question isn't solved yet. I don't remember if there is a solution with msgboxes, but there is sure one when you make your own msgboxes with using homemade userforms that opens the...

Glad to help.:)

Example when you want to choose de emails if you don't have to send to all the adresses. I added and example how your Volunteers page should look like. Sub gandal() ' ' EmailCopy Macro Dim cell As Range Dim rng As Range Dim objOutlook As Object, OutMail As Object Dim strto As...