Excel toggle strikethrough

$10-30 AUD

Ukończony

Opublikowano

około 4 lata temu

$10-30 AUD

Płatne przy odbiorze

Upon execution of the macro 1. Macro establishes the text whic is to be actied upon 2. The text may be 2a - That of a highlighted cell OR it may be 2b - Text highlighted within a cell 3. Macro established the strikethrough status of the text in question 4. Macro toggles the strikethrough status of said text. Example 1 - Cell A1 is selected and has text "aaaaa bbbbb ccccc" Executing macro with cause the text to have strikethrough effect enabled. Executing the macro again causes the text to have the strikethrough effect removed. Example 2 - Cell A1 is selected and has text "aaaaa bbbbb ccccc" F2 has been struck so that the cell test is being edited. Cal this in-cell-edit-mode The last portion of text "ccccc" has been selected by holding the shift key down and pressing back arrow 5 times Executing macro with cause the text "ccccc" only to have strikethrough effect enabled. The other text in the cell "aaaaa bbbbb" is unaffected Once the macro ends it is not important if in-cell-edit-mode is stil active. It may be that once the macro ends the cursor is no longer in in-cell-edit-mode but the entire cell is highlighted by the cursor

Excel

Visual Basic

Visual Basic for Apps

Identyfikator projektu: 24783020

Informację o projekcie

14 ofert

Zdalny projekt

Aktywny 4 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@indrapandu

Hi, I'm excel VBA expert. I've understood your requirements and goals. Let's have a chat for further discussion.

$30 AUD w 1 dzień

5,0

(52 opinii)

5,2

14 freelancerzy składają oferty o średniej wysokości $42 AUD dla tej pracy

@P0L

Hello, I’m an Excel expert and I would like to help you with your macro. Please send me a message so that we can discuss more.

$30 AUD w 1 dzień

4,9

(367 opinii)

7,5

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. Contact me to discuss the details. Best regards

$50 AUD w 2 dni

4,9

(250 opinii)

7,0

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Willing and looking forward to working with you. Thank you, Regards.

$30 AUD w 1 dzień

5,0

(119 opinii)

6,4

@gokulanand

Hello I can get you a macro written to achieve this toggling of striking the selected text. I can start the task right away and get it done in 2 hours. Do let me know if you are interested. Thanks Gokul

$30 AUD w 1 dzień

5,0

(100 opinii)

6,1

@finecodervw

Hi, Keen to work on this. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

$30 AUD w 1 dzień

4,9

(97 opinii)

6,0

@isupportu

Hi I can do this. I will create a demo Macro to toggle the strike through as you mention in a couple of hour. I noticed in your example 2 , you try to run Macro in cell edit mode , But Excel wont allow this. The example 2 is not possible. Please initiate the chat to start the work. Thanks, ISupportU

$20 AUD w 1 dzień

4,9

(14 opinii)

3,6

@mandarvvaidya

Good day! Fantastic description! All a programmer needs is a precise specification like you have given. I have FULL CONFIDENCE of completing this Excel VBA macro precisely as you need. Note that I can provide desired toggle functionality for BOTH THE CASES, viz. 2a and 2b. Further, you can assign the macro to a keyboard shortcut. I can even add the keyboard shortcut through VBA. Although new to Freelancer.com, I have EXTENSIVE EXPERIENCE (> 11 years) in Excel, Formulas, and VBA. Thanks, Tushar

$25 AUD w 1 dzień

4,9

(3 opinii)

2,6

@srikanthdavuluri

Hi, I am an expert in VBA excel macro development and can deliver the project requirement which you mentioned in a day.

$10 AUD w 1 dzień

5,0

(1 opinia)

0,3

@snkaswan

• Top-Rated Seller • Quick Turnaround • Quality Customer Support Please click on the CHAT button to further discuss the project. Kind regards, salini

$30 AUD w 1 dzień

0,0

(0 opinii)

0,0

@kishore1702

I have knowledge about spread sheet and I had done some MNC data entry works, Aadhar works,etc,. I know typewriting as well, its easy to work on your project. If you give opportunity I'll do my level best incase you're not satisfied on my work. I'll accept the payment what you give. Thank you.

$20 AUD w 4 dni

0,0

(0 opinii)

0,0

@nirajthaur

I am very skilled in data entry and Excel works. I am also very qualified in data extracting and tele communicating. If you hire me, you will get many services at one time investment. I am very much confident of our succession together as I am punctual and creative.I look forward to hear from you soon. Thank you.

$250 AUD w 1 dzień

0,0

(0 opinii)

0,0

@mahfuzrahaman

Dear Hiring Manager, At first take my sincere respect. I have gone through your project description and i understand .I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. . This is a big project but it's easy task. I'm new here but I've done projects like this before. I can see you if you want. I am able to do this job. I can do your job as your demand. I can start anytime if you allow me. I will give you unlimited revision before and after the job. Currently I am not worrying about the budget. Getting a good review is my highest priority. Best regards, Mahfuz

$20 AUD w 1 dzień

5,0

(1 opinia)

0,2

@lmiredata

Hi there, I just came across your project and wanted to let you know that there is an Excel shortcut that will allow you to do this strikethrough very easily and per your requirements above. Try holding the Ctrl key and then hitting the number 5. It will strikethrough and also remove it. I'm not sure if there was a particular reason you wanted a macro vs. using this, so if that's the case then definitely disregard. No need to pay me anything - just trying to help out. If this does end up being helpful, a review would be awesome as I am new to this site and am trying to get some work or supplemental income but also don't feel obligated. Thanks! Logan

$10 AUD w 1 dzień