Find Jobs
Hire Freelancers

Make cells act like TV subtitles - 02/05/2018 03:43 EDT

$10-30 USD

Stengt
Lagt ut nesten 6 år siden

$10-30 USD

Betalt ved levering
I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).
Prosjekt-ID: 16858961

Om prosjektet

5 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
5 freelancers are bidding on average $29 USD for this job
Brukeravatar
Hi, I have read very carefully your project details about creating an Excel Macros to limit cells to some specific number of characters. I am absolutely sure that I can complete this project professionally. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you have entrusted this task. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
$30 USD om 1 dag
5,0 (8 omtaler)
4,1
4,1
Brukeravatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$35 USD om 1 dag
5,0 (2 omtaler)
2,6
2,6
Brukeravatar
Hello, Having read your post id like to introduce myself. My name is Arjun and iam a very experienced programmer in VBA and excel. Id like to inform you that the functionality you are looking for is not possible in excel. Even if you achieve this, it will be highly in-consistant. It will work sometimes and sometimes it won't. The most widely used approach to do this would be to insert the code in the worksheet change event. If you are open to using a VBA Userform then i can quickly give you a small tool to achieve what you want. i.e. control on the no of lines and characters. It would be great if we could chat and discuss the project in detail. Thanks Arjun
$35 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
This is a very interesting macro request. I just finished a preliminary tool to fulfill the cell restriction rule. Here are some features from my tool: 1. firstly I choose a specific area to restrict the cells, e.g, A1:M10 in sheets(1); 2. Supposed the maxmium of characters of each line is 3, if a string which has more than 3 characters of one line is filled in the area aforementioned, then the string will be deleted and a pop up box will appear alerting the mistake. (The row limit is similar to this rule) 3. The restrict area and maxmium characters/rows can be customized. I am looking foward to cooperate with you. Thank you.
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

EGYPTs flagg
Alexandria, Egypt
0,0
0
Medlem siden nov. 12, 2006

Klientbekreftelse

Andre jobber fra denne klienten

Make cells act like TV subtitles
$10-30 USD
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.