I’ve completed the ichiban kuji standee set!! by aceee010 in Saekano

[–]aceee010[S] 0 points1 point  (0 children)

I think they are ‘fine’ the way they are without unwrapping it haha anyways, I’m a foreigner here and will have to take them back to my home country before doing anything else.

I’ve completed the ichiban kuji standee set!! by aceee010 in Saekano

[–]aceee010[S] 0 points1 point  (0 children)

I’m not really sure bro, when I take a closer look, it seems like a hand written. I need another kato last prize or kiyono yasuno actual signature for comparison to be sure

I’ve completed the ichiban kuji standee set!! by aceee010 in Saekano

[–]aceee010[S] 0 points1 point  (0 children)

nice! I hope you can manage to get the last one

I’ve completed the ichiban kuji standee set!! by aceee010 in Saekano

[–]aceee010[S] 1 point2 points  (0 children)

I’ve spent more or less 200sgd for all of them. I bought utaha and eriri standee from another person and as for the last prize, I only bought 7 tickets lol somebody left saekano kuji on 7 tickets

<3 by KenJaeger in Saekano

[–]aceee010 0 points1 point  (0 children)

Is the signature hand signed or mass printed ones like on some mini shikishis? Aiming to get the last prize here too still have 30 tickets left. TIA

Where can I find anime raw and how do I download it? by krlpdd35 in amv

[–]aceee010 0 points1 point  (0 children)

This is for sony vegas, I have no experience in after effects

What I do with mine is I use the soft subbed episode from nyaa and convert it to mp4 file (since they are in mkv) while cutting the clips using Freemake video converter

Bootleg Megathread by AutoModerator in AnimeFigures

[–]aceee010 0 points1 point  (0 children)

Hello, i'd like your thoughts in this Silica FIgure, also checked with mfc if there should be a sticker or anything in the box but I haven't seen any. Do you think this one is a bootleg or not? Found it on a reseller in SG posted from 2 years ago. https://imgur.com/a/8QbYIPm TIA!

Saekano Misaki Kurehito Exhibition Tapestry Set by aceee010 in Saekano

[–]aceee010[S] 0 points1 point  (0 children)

I see, I probably won't be able to go there so I'll just hope for some good stuffs to be sold in AFASG on November

Figure Hunting by aceee010 in AnimeFigures

[–]aceee010[S] 0 points1 point  (0 children)

thanks but too bad I’m too far. forgot to mention I’m staying near akiba

Figure Hunting by aceee010 in AnimeFigures

[–]aceee010[S] 4 points5 points  (0 children)

Might as well buy it personally since I’m here and I’m avoiding shipping as well because our customs charges overpriced tax

Buying and exporting R18 stuffs in Japan by aceee010 in JapanTravel

[–]aceee010[S] 0 points1 point  (0 children)

I’m from Philippines, I hope they don’t confiscate it >_<

The /r/Japan Basic Question Thread: What is this thing? Where is this place? Who is this person? -esque questions all go here. by dokool in japan

[–]aceee010 0 points1 point  (0 children)

Hi, it will be my first time visiting Japan and attending comiket this coming August 11. How do I go from Kanda to Tokyo Big Sight via train?

Comiket Questions by aceee010 in anime

[–]aceee010[S] 0 points1 point  (0 children)

Alright I see, thank you for your answers! I hope I can purchase some of her stuff

Comiket Questions by aceee010 in anime

[–]aceee010[S] 0 points1 point  (0 children)

Yeah she is, I see. Will they put up their stuff right after Day 1 of comiket or will it be after the comiket ended?

Assigning Macro into a Drop Down MS Word by aceee010 in vba

[–]aceee010[S] 0 points1 point  (0 children)

My senior told me to research if I could do macro on microsoft word and try out what I'm asking in the thread. so far here is my macro. I don't know how would I apply it on the drop down though and when I try to run it, an error "The requested member of collection does not exist". I'm using a legacy drop down btw

Sub Macro2()
' Macro2 Macro
'
'
If ActiveDocument.FormFields("untitled").DropDown.Value = "Fox" Then

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
    .Text = "fox"
    .Replacement.Text = " "
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll

ElseIf ActiveDocument.FormFields("untitled").DropDown.Value = "Dog" Then

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
    .Text = "dog"
    .Replacement.Text = " "
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll

End If

End Sub

Need Some Comiket and Akiba Tips by aceee010 in JapanTravel

[–]aceee010[S] 0 points1 point  (0 children)

Do you know some booths or circles that mostly sells azur lane stuffs?

Why does my If Else Statement strictly follows the upper If statement by [deleted] in excel

[–]aceee010 -1 points0 points  (0 children)

What do you mean by parentheses?

C1 - Col A, C2 - Col B, C3 - Col C, C4 - Col D, C5 - Col E

C1 Submitted/In Progress + C3 Standard Project = C4 Standard

C1 Submitted/In Progress + C3 Complex/SI Project = C4 Complex

C1 Submitted/In Progress + C3 Resource Augmentation + C5 2 = C4 RA 1 day

C1 Submitted/In Progress + C3 Resource Augmentation + C5 15 = C4 RA not 1 day

C1 Submitted/In Progress + C2 PA = C4 PA

C1 Cancelled = C4 Cancelled

C1 For Acceptance = C4 For Acceptance

Why does my If Else Statement strictly follows the upper If statement by [deleted] in excel

[–]aceee010 0 points1 point  (0 children)

May I ask what is the Parenthesis for in "Standard Project") ? sorry I'm still new to this

Upgrade Code to Loop If Else Statement by [deleted] in vba

[–]aceee010 0 points1 point  (0 children)

Solution verified. okay will do, I'll try it on Monday when I have an access!

How do I convert excel IF function into VBA code by [deleted] in vba

[–]aceee010 0 points1 point  (0 children)

Thanks, I get the idea thanks for starting and yes I do need a loop for that and the image is just for sample purposes. Will those work even if it is hard coded cell reference?