front

Hi all, I would like to use a VBA code so that to copy next to each earnings or deductions or contributions, the department which is in col. “C”. Therefore, that the rows are not stably and I present just an extract of data. There are also deductions & contributions. Below the original data and...

Thanks for your advice. I have thousands of lines of unique 16 digit numbers. I would like to front zero fill digits 17 thru 20. Thanks again - Tom

Hi please can you help me, I have the cold below where I want the "comments" to be in bold, how do I do this please? I have tried the <B> in front of the comments but this didn't work. "Comments: " & Me.TextBox9.Value & Chr(10) & _

Greetings I use the following notation to report certain values. >1.000 <0.0001 These values are in units of micromolar. I would like some code to convert them to the following. >1.00E-06 <1.00E-10 I have something like this.. Sub Tidy_IC50() ' Tidy IC50 value if >1.000000 Dim dData As...

Hi, I have a workbook showing the jobs which consultants are being paid for in the latest payment run. This consists of a front sheet and then a sheet for each consultant. I'd like to run a macro which emails the relevant sheet as an attachment to the relevant recipient. I would imagine...

I found the below Macro for selecting all lines on my page and it works great. Can someone tell me what I need to add to it to move all the selected objects to the front, then de-select everything? Thanks! Sub Macro1() Dim aShape As Shape Range("a1").Select For Each aShape In...

I am on Win10 using Office 360. I added the Front and Back buttons but they remain "dimmed out" non-functional. Any explanations as to why?? Thank You -emp1953

Hello... I'm using Excel 2010 and I have an issue with some pictures. I load some pictures with the below code and I want to remove a specific one or bring in front the other one. The problem is that any time I load a picture the excel name is different and I dont know a way to find that name to...

My excel crashes a lot and when it does i have to resave and rename all of my workbooks, usually about 7 into their individual folder. i'm tired of this. i'm trying to get excel to save all workbooks periodically. the problem with the following code is that it freezes excel while its running...

My employer asked me to strip https://www.citb.co.uk/cards-testing/online-card-checker/ to check all employees of valid constitution cards. All code is working fine but at some point after number of "For each" my VBA returns error. It turns out that cookie notification go at front of the web...

Hello knowledgeable users! I am trying to fix a series of numbers. in E2 it reads: 20180809173450Z I want it to be: 08092018 This is what I have so far: =MID(E2,7,2)&LEFT(E2,LEN(E2)-9) Which returns 09201808. Ok almost there, just have to do that same thing to put 08 in front of the...

Hello- Curious if there is a way to save a form that is used mulitples times that is in a front end database? I dont see how you can save and will that effect the back end database feeding the information in? Thanks!

Hey Gang I have a macro that selects the print area of a single page in a workbook and emails it to a list. When the page is received and viewed it displays as two pages (Front & back of the page). But when the people receive the page and attempt to print it it defaults to printing 6 pages and...

Hi, I'm trying to convert a date that's typed as "11/12/2018" into "201211". So I want to drop the year, convert the 12 into 2012, move it to the front, and follow it with the 11. Some of the dates have less digits. For example 7/15/2018 would need to become 201507. Thanks!

Hello, I am trying to do a sheet where i look up data and bring back a total. I have 2 spreadsheets 1 with the data and 1 as a front sheet. I need the front sheet to look at the data and bring back the total. This is the data sheet <colgroup><col><col><col span="4"></colgroup><tbody>...

Hello- I have created a spilt DB for users who will be using different forms from the front end database. I have come to find out that when updates are made to the backend database they will not transfer to the front end database unless the backend database is saved on a shared network. The...

I have a userform and when I click on a button, it opens a new workbook, but the workbook is behind the userform. I want to bring the new workbook to the front, without having to hide the userform, so when the person is exits the new orkbook, the userform is still there for use. Thanks Mike

Hi, I created a dashboard for work and a part of the screen it allows you to select different charts (Top location breakdown, custmer breakdow etc.. Basically when criterai in cell is select it will bring that chart/analysis to the front of the area. They asked if I could add Key stats option...

I can't get multiple users in a new database. When I've written previous databases, I split them and made multiple front ends and had no issues. I've been working for weeks on this and can't figure it out. What I've Tried: 1. The database is split and the BE is in a separate folder from the...

I need a non-VBA solution to bringing objects to the front (or making visible, etc.).